insert data to the DB only if it's not already exist

Asked Mar 11 '15 at 13:22

Active Mar 11 '15 at 13:28

Viewed 188 times

I would like to insert data to the DB only if it's not already exist. so I'm using INSERT IGNORE.

The problem is with field "createDate" - it's change every second and that's turn the new data to be new/unique. Is there any way to set the comparison fields for the SQL ?

$res = mysql_query ("INSERT IGNORE INTO `alerts` (userID, type, refID, title, openBy, createDate) VALUES (".$mainIndex['userID'].", 'comment',  ".$mainIndex['id'].", '".$contactName."', ".$mainIndex['userID'].", ".$todayLX.")");

edited Mar 11 '15 at 13:28

jarlh

42,561
8
45
63

asked Mar 11 '15 at 13:22

Roi

Is createDate marked as a UNIQUE field in your database? – Naruto Mar 11 '15 at 13:24
no...@Naruto.................................. – Roi Mar 11 '15 at 13:29
so try insert without date and then update if record inserted, or check before insert if data exists – szapio Mar 11 '15 at 13:34
see http://stackoverflow.com/questions/913841/mysql-conditional-insert – Federico Sierra Mar 11 '15 at 13:34
Define "exists", then put a unique key on it. – Marcus Adams Mar 11 '15 at 13:35
insert ignore works only when one of the inserting field is unique. – sachin Mar 11 '15 at 14:28

insert data to the DB only if it's not already exist

0 Answers0