MYSQL if/else clause

Question

I need to do a such thing in SQL but I don't know how...

IF *row exists* THEN  
  UPDATE ...
ELSE
 CREATE ...

I can't figure how to do that..

Your question is very undefined. Is this if a record already exists in a table then update the record; or is it create a table if the table doesn't exist? — Suroot
– Suroot, Commented Jun 20, 2011 at 2:53

Joshua Martell · Accepted Answer · 2011-06-20 02:54:07Z

4

INSERT ... ON DUPLICATE KEY UPDATE.... or REPLACE should do the trick:

ON DUPLICATE KEY UPDATE http://dev.mysql.com/doc/refman/5.0/en/insert-on-duplicate.html

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

answered Jun 20, 2011 at 2:54

Joshua Martell

7,2122 gold badges33 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

SBSTP Over a year ago

INSERT INTO lang (ip, lang) VALUES('$ip', 'fr') ON DUPLICATE KEY UPDATE SET lang='fr' WHERE ip='$ip'; This doesn't seem to work.

Joshua Martell Over a year ago

@user576488, this should be INSERT INTO lang (ip, lang) VALUES('$ip', 'fr') ON DUPLICATE KEY UPDATE lang='fr'. This also requires a collision of the unique keys on the table. What's your table structure look like?

John Boker · Accepted Answer · 2011-06-20 02:54:46Z

0

You can use a normal insert statement with a ON DUPLICATE KEY UPDATE described in the docs :

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

answered Jun 20, 2011 at 2:54

John Boker

83.8k17 gold badges101 silver badges130 bronze badges

Collectives™ on Stack Overflow

MYSQL if/else clause

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related