[DiscordArchive] ask chatgpt ?
[DiscordArchive] ask chatgpt ?
Original source
you can do a lot more with querys compared to filters. like selecting all creature_templates for npcs in sfk
```sql
SELECT DISTINCT creature_template.* FROM creature_template
INNER JOIN creature ON creature_template.entry = creature.id1
WHERE creature.map IN (33);
```
rektbyfaith
02-20-2024, 01:41 AM #31Archived author: Degen • Posted: 2024-02-20T01:41:12.467000+00:00
Original source
you can do a lot more with querys compared to filters. like selecting all creature_templates for npcs in sfk
```sql
SELECT DISTINCT creature_template.* FROM creature_template
INNER JOIN creature ON creature_template.entry = creature.id1
WHERE creature.map IN (33);
```
Original source
joins
rektbyfaith
02-20-2024, 01:46 AM #32Archived author: Rymercyble • Posted: 2024-02-20T01:46:56.848000+00:00
Original source
joins
Original source
https://tenor.com/view/po-dies-dies-of-d...f-23885910
rektbyfaith
02-20-2024, 01:47 AM #33Archived author: Rymercyble • Posted: 2024-02-20T01:47:00.995000+00:00
Original source
https://tenor.com/view/po-dies-dies-of-d...f-23885910
Original source
joins are great. you just gotta pretend like you know what one to use
rektbyfaith
02-20-2024, 01:56 AM #34Archived author: Degen • Posted: 2024-02-20T01:56:17.470000+00:00
Original source
joins are great. you just gotta pretend like you know what one to use
Original source
I don't rly write raw queries I'm used to use ORM otherwise I would go insane
rektbyfaith
02-20-2024, 01:57 AM #35Archived author: Rymercyble • Posted: 2024-02-20T01:57:31.969000+00:00
Original source
I don't rly write raw queries I'm used to use ORM otherwise I would go insane
1 Guest(s)
1 Guest(s)