[DiscordArchive] <@&408012830147739658> I'm kinda mediocre when it comes to more than completely basic SQL stuff, can
[DiscordArchive] <@&408012830147739658> I'm kinda mediocre when it comes to more than completely basic SQL stuff, can
Original source
<@&408012830147739658> I'm kinda mediocre when it comes to more than completely basic SQL stuff, can someone help me?
rektbyfaith
02-16-2018, 07:58 PM #1Archived author: Amaroth • Posted: 2018-02-16T19:58:49.082000+00:00
Original source
<@&408012830147739658> I'm kinda mediocre when it comes to more than completely basic SQL stuff, can someone help me?
Original source
SELECT (entry, class, subclass, SoundOverrideSubclass, Material, displayid, InventoryType, sheath) FROM item_template WHERE entry BETWEEN 100 AND 200;
I think you see what I want to achieve
rektbyfaith
02-16-2018, 07:59 PM #2Archived author: Amaroth • Posted: 2018-02-16T19:59:18.524000+00:00
Original source
SELECT (entry, class, subclass, SoundOverrideSubclass, Material, displayid, InventoryType, sheath) FROM item_template WHERE entry BETWEEN 100 AND 200;
I think you see what I want to achieve
Original source
This outputs Error Code: 1241 Operand should contain 1 column(s)
rektbyfaith
02-16-2018, 07:59 PM #3Archived author: Amaroth • Posted: 2018-02-16T19:59:32.076000+00:00
Original source
This outputs Error Code: 1241 Operand should contain 1 column(s)
Original source
I found some topics on StackOverflow and so on but still can't figure out how to write this correctly to make it work
rektbyfaith
02-16-2018, 07:59 PM #4Archived author: Amaroth • Posted: 2018-02-16T19:59:50.645000+00:00
Original source
I found some topics on StackOverflow and so on but still can't figure out how to write this correctly to make it work
Original source
```SQL
SELECT entry, class, subclass, SoundOverrideSubclass, Material, displayid, InventoryType, sheath
FROM item_template
WHERE entry BETWEEN 100 AND 200;```
rektbyfaith
02-16-2018, 08:03 PM #5Archived author: Barbz • Posted: 2018-02-16T20:03:17.887000+00:00
Original source
```SQL
SELECT entry, class, subclass, SoundOverrideSubclass, Material, displayid, InventoryType, sheath
FROM item_template
WHERE entry BETWEEN 100 AND 200;```
Original source
this works
rektbyfaith
02-16-2018, 08:03 PM #6Archived author: Barbz • Posted: 2018-02-16T20:03:19.560000+00:00
Original source
this works
Original source
Call me bloody idiot.
rektbyfaith
02-16-2018, 08:08 PM #7Archived author: Amaroth • Posted: 2018-02-16T20:08:11.275000+00:00
Original source
Call me bloody idiot.
Original source
And thanks
rektbyfaith
02-16-2018, 08:08 PM #8Archived author: Amaroth • Posted: 2018-02-16T20:08:25.709000+00:00
Original source
And thanks
1 Guest(s)
1 Guest(s)