[DiscordArchive] or where the set emote is in the sql?
[DiscordArchive] or where the set emote is in the sql?
Original source
or where the set emote is in the sql?
rektbyfaith
07-03-2024, 05:14 PM #1Archived author: ▶ •၊၊||၊|၊• • Posted: 2024-07-03T17:14:51.399000+00:00
Original source
or where the set emote is in the sql?
Original source
Trying to edit a module, more specifically the SQL file. I just had a quick coding question. Do you have to repeat the "insert into" every time like this person did..
```INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`, `VerifiedBuild`) VALUES (@Vendor_Wep, 0,42210 , 0, 0, 2986, 0);
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`, `VerifiedBuild`) VALUES (@Vendor_Wep, 0,42229 , 0, 0, 2986, 0);
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`, `VerifiedBuild`) VALUES (@Vendor_Wep, 0,42234 , 0, 0, 2986, 0); ```
or can I simplify down to something like this?
```/* LEVELING ARMOR LIST */
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`, `VerifiedBuild`) VALUES
(@Vendor_Arm, 0, 48691, 0, 0, 0, 0), -- Tattered Dreadmist Robe
(@Vendor_Arm, 0, 42985, 0, 0, 0, 0), -- Tattered Dreadmist Mantle
(@Vendor_Arm, 0, 48689, 0, 0, 0, 0), -- Stained Shadowcraft Tunic
(@Vendor_Arm, 0, 40588, 0, 0, 0, 0), -- Preened Ironfeather Breastplate
(@Vendor_Arm, 0, 40601, 0, 0, 0, 0), -- Stained Shadowcraft Spaulders```
rektbyfaith
07-03-2024, 05:54 PM #2Archived author: Nadroj • Posted: 2024-07-03T17:54:42.013000+00:00
Original source
Trying to edit a module, more specifically the SQL file. I just had a quick coding question. Do you have to repeat the "insert into" every time like this person did..
```INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`, `VerifiedBuild`) VALUES (@Vendor_Wep, 0,42210 , 0, 0, 2986, 0);
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`, `VerifiedBuild`) VALUES (@Vendor_Wep, 0,42229 , 0, 0, 2986, 0);
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`, `VerifiedBuild`) VALUES (@Vendor_Wep, 0,42234 , 0, 0, 2986, 0); ```
or can I simplify down to something like this?
```/* LEVELING ARMOR LIST */
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`, `VerifiedBuild`) VALUES
(@Vendor_Arm, 0, 48691, 0, 0, 0, 0), -- Tattered Dreadmist Robe
(@Vendor_Arm, 0, 42985, 0, 0, 0, 0), -- Tattered Dreadmist Mantle
(@Vendor_Arm, 0, 48689, 0, 0, 0, 0), -- Stained Shadowcraft Tunic
(@Vendor_Arm, 0, 40588, 0, 0, 0, 0), -- Preened Ironfeather Breastplate
(@Vendor_Arm, 0, 40601, 0, 0, 0, 0), -- Stained Shadowcraft Spaulders```
Original source
You can do a bulk insert, yes, exactly like that
rektbyfaith
07-03-2024, 05:55 PM #3Archived author: Nyeriah • Posted: 2024-07-03T17:55:44.820000+00:00
Original source
You can do a bulk insert, yes, exactly like that
Original source
Perfect, thank you!
rektbyfaith
07-03-2024, 05:55 PM #4Archived author: Nadroj • Posted: 2024-07-03T17:55:53.460000+00:00
Original source
Perfect, thank you!
Original source
The last line ends with the delimiter
rektbyfaith
07-03-2024, 05:56 PM #5Archived author: Nyeriah • Posted: 2024-07-03T17:56:17.757000+00:00
Original source
The last line ends with the delimiter
Original source
Usually a semi column
rektbyfaith
07-03-2024, 05:56 PM #6Archived author: Nyeriah • Posted: 2024-07-03T17:56:23.928000+00:00
Original source
Usually a semi column
Original source
That makes sense, thank you for the quick syntax check.
rektbyfaith
07-03-2024, 05:56 PM #7Archived author: Nadroj • Posted: 2024-07-03T17:56:47.693000+00:00
Original source
That makes sense, thank you for the quick syntax check.
Original source
Yeah Those old queries were overthought a bit. Looks a lot like mine when I was learning sql <:kek:1065379143887372398>
rektbyfaith
07-03-2024, 06:46 PM #8Archived author: Nelnamara • Posted: 2024-07-03T18:46:18.498000+00:00
Original source
Yeah Those old queries were overthought a bit. Looks a lot like mine when I was learning sql <:kek:1065379143887372398>
1 Guest(s)
1 Guest(s)