IF NOT EXIST UPDATE ALSE INSERT

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
meee
Forum Newbie
Posts: 18
Joined: Wed Feb 04, 2009 1:38 pm

IF NOT EXIST UPDATE ALSE INSERT

Post by meee »

I am trying to make a right syntax but I don't know how. Please help me to correct it:

Code: Select all

 
mysql_query("IF NOT EXISTS (INSERT INTO users (firstName, lastName, id2, gender) VALUES ('Nick', 'AAAA', '4', 'm')) ELSE (UPDATE users SET firstName='Nick', lastName='AAAA', id2='4', gender='m' WHERE ID='4')") or die (mysql_error());
 
//or
 
mysql_query("IF EXISTS (UPDATE users SET firstName='Nick', lastName='AAAA', id2='4', gender='m' WHERE ID='4') ELSE (INSERT INTO users (firstName, lastName, id2, gender) VALUES ('Nick', 'AAAA', '4', 'm'))") or die (mysql_error());
 
User avatar
sergio-pro
Forum Commoner
Posts: 88
Joined: Sat Dec 27, 2008 12:26 pm

Re: IF NOT EXIST UPDATE ALSE INSERT

Post by sergio-pro »

meee
Forum Newbie
Posts: 18
Joined: Wed Feb 04, 2009 1:38 pm

Re: IF NOT EXIST UPDATE ALSE INSERT

Post by meee »

thanks, but I can not use this because when updating I don't know primary key row.
User avatar
sergio-pro
Forum Commoner
Posts: 88
Joined: Sat Dec 27, 2008 12:26 pm

Re: IF NOT EXIST UPDATE ALSE INSERT

Post by sergio-pro »

I'm afraid you cannot make "IF NOT EXISTS (INSERT" in MySql query.

You need to make a SELECT first, to find out if row exists.
Post Reply