[DiscordArchive] should I be using ' or ` for table names?
[DiscordArchive] should I be using ' or ` for table names?
Original source
should I be using ' or ` for table names?
rektbyfaith
06-05-2023, 08:22 PM #1Archived author: Lonk • Posted: 2023-06-05T20:22:00.989000+00:00
Original source
should I be using ' or ` for table names?
Original source
`
rektbyfaith
06-05-2023, 08:23 PM #2Archived author: Tereneckla • Posted: 2023-06-05T20:23:32.972000+00:00
Original source
`
Original source
might explain the persistent syntax errors
rektbyfaith
06-05-2023, 08:23 PM #3Archived author: Lonk • Posted: 2023-06-05T20:23:55.663000+00:00
Original source
might explain the persistent syntax errors
Original source
```sql
USE `acore_world`;
SELECT ('item') FROM 'mod_auctionhousebot_disabled_items' a WHERE EXISTS(SELECT ('item') FROM 'disenchant_loot_template');```
rektbyfaith
06-05-2023, 08:25 PM #4Archived author: Lonk • Posted: 2023-06-05T20:25:18.496000+00:00
Original source
```sql
USE `acore_world`;
SELECT ('item') FROM 'mod_auctionhousebot_disabled_items' a WHERE EXISTS(SELECT ('item') FROM 'disenchant_loot_template');```
Original source
Now all I need to do is delete the rows it finds, seems to work well so far thank you both
rektbyfaith
06-05-2023, 08:26 PM #5Archived author: Lonk • Posted: 2023-06-05T20:26:31.692000+00:00
Original source
Now all I need to do is delete the rows it finds, seems to work well so far thank you both
Original source
You don't have to have that `a` after the table name unless you're using joins etc btw
rektbyfaith
06-05-2023, 08:26 PM #6Archived author: Revision • Posted: 2023-06-05T20:26:53.339000+00:00
Original source
You don't have to have that `a` after the table name unless you're using joins etc btw
Original source
I thought I deleted that O.o
rektbyfaith
06-05-2023, 08:27 PM #7Archived author: Lonk • Posted: 2023-06-05T20:27:04.289000+00:00
Original source
I thought I deleted that O.o
Original source
Basically selecting from multiple tables you use that to handle it
rektbyfaith
06-05-2023, 08:27 PM #8Archived author: Revision • Posted: 2023-06-05T20:27:32.357000+00:00
Original source
Basically selecting from multiple tables you use that to handle it
Original source
deleted
rektbyfaith
06-05-2023, 08:28 PM #9Archived author: Lonk • Posted: 2023-06-05T20:28:34.206000+00:00
Original source
deleted
Original source
oh I know what I did
rektbyfaith
06-05-2023, 08:29 PM #10Archived author: Lonk • Posted: 2023-06-05T20:29:01.034000+00:00
Original source
oh I know what I did
1 Guest(s)
1 Guest(s)