[DiscordArchive] Pretty new to all this but i'd like to easily add a bunch of characters to a guild (basically a hord
[DiscordArchive] Pretty new to all this but i'd like to easily add a bunch of characters to a guild (basically a hord
Original source
Pretty new to all this but i'd like to easily add a bunch of characters to a guild (basically a horde & alliance guild).
This was the query i tinkered, but it doesn't work
INSERT INTO guild_member (guild_id, guid, rank)
SELECT 1, guid, 4
FROM characters
WHERE race IN (2, 5, 6, 8, 10);
Anyone with more knowledge knows where i went wrong?
rektbyfaith
10-26-2024, 05:45 AM #1Archived author: Dohtt • Posted: 2024-10-26T05:45:10.100000+00:00
Original source
Pretty new to all this but i'd like to easily add a bunch of characters to a guild (basically a horde & alliance guild).
This was the query i tinkered, but it doesn't work
INSERT INTO guild_member (guild_id, guid, rank)
SELECT 1, guid, 4
FROM characters
WHERE race IN (2, 5, 6, 8, 10);
Anyone with more knowledge knows where i went wrong?
Original source
use `INSERT IGNORE INTO`
rektbyfaith
10-26-2024, 06:45 AM #2Archived author: OUTRAKE • Posted: 2024-10-26T06:45:02.745000+00:00
Original source
use `INSERT IGNORE INTO`
1 Guest(s)
1 Guest(s)