[DiscordArchive] should I be using ' or ` for table names?
[DiscordArchive] should I be using ' or ` for table names?
Original source
I pasted from my local machines clipboard, not the VM clipboard
rektbyfaith
06-05-2023, 08:29 PM #11Archived author: Lonk • Posted: 2023-06-05T20:29:15.682000+00:00
Original source
I pasted from my local machines clipboard, not the VM clipboard
Original source
```sql
USE `acore_world`;
SELECT `item` FROM `mod_auctionhousebot_disabled_items` WHERE `item` IN (SELECT `item` FROM `disenchant_loot_template`);```
rektbyfaith
06-05-2023, 08:30 PM #12Archived author: Lonk • Posted: 2023-06-05T20:30:08.719000+00:00
Original source
```sql
USE `acore_world`;
SELECT `item` FROM `mod_auctionhousebot_disabled_items` WHERE `item` IN (SELECT `item` FROM `disenchant_loot_template`);```
Original source
there, thats better
rektbyfaith
06-05-2023, 08:30 PM #13Archived author: Lonk • Posted: 2023-06-05T20:30:15.976000+00:00
Original source
there, thats better
Original source
I assume I can just modify it to:
```sql
USE `acore_world`;
DELETE `item` FROM `mod_auctionhousebot_disabled_items` WHERE `item` IN (SELECT `item` FROM `disenchant_loot_template`);```
When I confirm I'm happy with the selected results
rektbyfaith
06-05-2023, 08:31 PM #14Archived author: Lonk • Posted: 2023-06-05T20:31:17.361000+00:00
Original source
I assume I can just modify it to:
```sql
USE `acore_world`;
DELETE `item` FROM `mod_auctionhousebot_disabled_items` WHERE `item` IN (SELECT `item` FROM `disenchant_loot_template`);```
When I confirm I'm happy with the selected results
Original source
```sql
DELETE FROM `mod_auctionhousebot_disabled_items` WHERE `item` IN (SELECT `item` FROM `disenchant_loot_template`);```
rektbyfaith
06-05-2023, 08:32 PM #15Archived author: Revision • Posted: 2023-06-05T20:32:59.221000+00:00
Original source
```sql
DELETE FROM `mod_auctionhousebot_disabled_items` WHERE `item` IN (SELECT `item` FROM `disenchant_loot_template`);```
Original source
Ah
rektbyfaith
06-05-2023, 08:33 PM #16Archived author: Lonk • Posted: 2023-06-05T20:33:10.732000+00:00
Original source
Ah
Original source
Awesome, I think that did it
rektbyfaith
06-05-2023, 08:34 PM #17Archived author: Lonk • Posted: 2023-06-05T20:34:35.347000+00:00
Original source
Awesome, I think that did it
Original source
Thank you so much for the help
rektbyfaith
06-05-2023, 08:34 PM #18Archived author: Lonk • Posted: 2023-06-05T20:34:39.694000+00:00
Original source
Thank you so much for the help
Original source
Always happy to help when I can
rektbyfaith
06-05-2023, 08:34 PM #19Archived author: Revision • Posted: 2023-06-05T20:34:47.702000+00:00
Original source
Always happy to help when I can
1 Guest(s)
1 Guest(s)