INSERT INTO ... ON DUPLICATE KEY UPDATE - Printable Version
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: INSERT INTO ... ON DUPLICATE KEY UPDATE (/showthread.php?tid=639171)
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: INSERT INTO ... ON DUPLICATE KEY UPDATE (/showthread.php?tid=639171)
INSERT INTO ... ON DUPLICATE KEY UPDATE - GoldenLion - 12.08.2017
Hi, I've decided to get rid of these "ItemPriceX" columns from my businesses table and create a separate table called "businessprices" that stores every business' item prices. There are 3 columns - "ID", "Item", "Price". When a business is created all the prices are 0 so there's no need of inserting the item price rows. However when you set the item's price I want it to insert a row into "businessprices" if one doesn't exist or update an existing row with the new price. I know there's "INSERT INTO ... ON DUPLICATE KEY UPDATE" for that, but I'm not sure how to use it. I've been googling quite a lot and trying, but I don't know how to get it working. I'd really appreciate that if someone explained me how this works and how to get it working.
Re: INSERT INTO ... ON DUPLICATE KEY UPDATE - Misiur - 12.08.2017
hhttp://sqlfiddle.com/#!9/58f674/1
Here you go. I didn't write constraints and indexes between table relationships (I've never written one by hand), but you should for maximum performance
Re: INSERT INTO ... ON DUPLICATE KEY UPDATE - GoldenLion - 12.08.2017
Quote:
|
Originally Posted by Misiur
 hhttp://sqlfiddle.com/#!9/58f674/1
Here you go. I didn't write constraints and indexes between table relationships (I've never written one by hand), but you should for maximum performance |
Re: INSERT INTO ... ON DUPLICATE KEY UPDATE - ISmokezU - 12.08.2017
I learnt it from a member here: https://dev.mysql.com/doc/refman/5.7...duplicate.html
An Example In Pawn:
PHP код:
mysql_format(MYSQL, query, sizeof(query)
,"INSERT INTO jail (Time) VALUES (%d) ON DUPLICATE KEY UPDATE Time = %d"
, time, time
);
mysql_tquery(MYSQL, query, "", "");
Re: INSERT INTO ... ON DUPLICATE KEY UPDATE - Misiur - 12.08.2017
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, "", "");
Re: INSERT INTO ... ON DUPLICATE KEY UPDATE - GoldenLion - 12.08.2017
Quote:
|
Originally Posted by ISmokezU
I learnt it from a member here: https://dev.mysql.com/doc/refman/5.7...duplicate.html
An Example In Pawn: PHP код:
|
Quote:
|
Originally Posted by Misiur
ISmokezU: You don't have to repeat your arguments, just use VALUES(column). So, it would be:
pawn Код:
|
Re: INSERT INTO ... ON DUPLICATE KEY UPDATE - ISmokezU - 12.08.2017
Quote:
|
Originally Posted by Misiur
ISmokezU: You don't have to repeat your arguments, just use VALUES(column). So, it would be:
pawn Код:
|
