INSERT INTO ... ON DUPLICATE KEY UPDATE
#5

ISmokezU: You don't have to repeat your arguments, just use VALUES(column). So, it would be:
pawn Код:
mysql_format(MYSQL, query, sizeof(query)
        ,"INSERT INTO jail (ID, Name, Time, Bail, Cell, Reason) VALUES (%d, '%e', %d, %d, %d, '%s') ON DUPLICATE KEY UPDATE Time = VALUES(Time), Bail = VALUES(Bail), Cell = VALUES(Cell), Reason = VALUES(Reason)"
        , Player[playerid][ID], GetName(playerid), time, bail, GetPlayerVirtualWorld(playerid), reason);
    mysql_tquery(MYSQL, query, "", "");
Reply


Messages In This Thread
INSERT INTO ... ON DUPLICATE KEY UPDATE - by GoldenLion - 12.08.2017, 18:30
Re: INSERT INTO ... ON DUPLICATE KEY UPDATE - by Misiur - 12.08.2017, 18:50
Re: INSERT INTO ... ON DUPLICATE KEY UPDATE - by GoldenLion - 12.08.2017, 18:57
Re: INSERT INTO ... ON DUPLICATE KEY UPDATE - by ISmokezU - 12.08.2017, 19:11
Re: INSERT INTO ... ON DUPLICATE KEY UPDATE - by Misiur - 12.08.2017, 19:14
Re: INSERT INTO ... ON DUPLICATE KEY UPDATE - by GoldenLion - 12.08.2017, 19:17
Re: INSERT INTO ... ON DUPLICATE KEY UPDATE - by ISmokezU - 12.08.2017, 19:17

Forum Jump:


Users browsing this thread: 1 Guest(s)