Jump to content

if value exists


b1011

Recommended Posts

use REPLACE instead of INSERT in your query

 

REPLACE works exactly like INSERT, except that if an old row in the table has the same value as a new row for a Primary Key or a UNIQUE index, the old row is deleted beore the new row is inserted.

be carefull when using REPLACE, it will delete the existing record and add a new row at the end which will leave spaces in any auto_inc columns.

 

 

http://dev.mysql.com/doc/refman/5.0/en/replace.html

Link to comment
https://forums.phpfreaks.com/topic/52380-if-value-exists/#findComment-258474
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.