Forums WoW Modding Support Archives TrinityCore Discord Archives [DiscordArchive] does anyone know a little bit about sql?

[DiscordArchive] does anyone know a little bit about sql?

[DiscordArchive] does anyone know a little bit about sql?

rektbyfaith
Administrator
0
02-05-2023, 06:38 PM
#1
Archived author: Krutok • Posted: 2023-02-05T18:38:48.064000+00:00
Original source

does anyone know a little bit about sql?
I'm looking for a sql command that gives me my entry from 196047 to 196058. SELECT entry, class,subclass,SoundOverrideSubclass,Material,displayid,InventoryType,sheath FROM item_template WHERE entry = 196047; gives me only one entry. how can I differentiate it that it outputs from to?
rektbyfaith
02-05-2023, 06:38 PM #1

Archived author: Krutok • Posted: 2023-02-05T18:38:48.064000+00:00
Original source

does anyone know a little bit about sql?
I'm looking for a sql command that gives me my entry from 196047 to 196058. SELECT entry, class,subclass,SoundOverrideSubclass,Material,displayid,InventoryType,sheath FROM item_template WHERE entry = 196047; gives me only one entry. how can I differentiate it that it outputs from to?

rektbyfaith
Administrator
0
02-05-2023, 06:44 PM
#2
Archived author: Gamemechanic • Posted: 2023-02-05T18:44:03.509000+00:00
Original source

select stuff from somewhere where entry>=lownumber and entry<=highnumber
rektbyfaith
02-05-2023, 06:44 PM #2

Archived author: Gamemechanic • Posted: 2023-02-05T18:44:03.509000+00:00
Original source

select stuff from somewhere where entry>=lownumber and entry<=highnumber

rektbyfaith
Administrator
0
02-05-2023, 06:48 PM
#3
Archived author: Krutok • Posted: 2023-02-05T18:48:01.520000+00:00
Original source

thank you works good
rektbyfaith
02-05-2023, 06:48 PM #3

Archived author: Krutok • Posted: 2023-02-05T18:48:01.520000+00:00
Original source

thank you works good

Recently Browsing
 1 Guest(s)
Recently Browsing
 1 Guest(s)