Combine Insert, Update and Select in MySQL

Question

Is there a way to combine an insert, update, and select query into one?

Kind of like in a condition, if select query, when the condition is true it will go to update and if not it will go to insert.

How can i do this?

Look up "insert on duplicate key update" in the documentation. — Gordon Linoff, Sep 11 '13 at 20:33
Look at this: http://stackoverflow.com/questions/14259249/mysql-insert-or-update-if — mavroprovato, Sep 11 '13 at 21:11

score 0 · Answer 1 · answered Sep 11 '13 at 21:09

0

STORED PROCEDURE is the ANSWER and IF/ELSE

answered Sep 11 '13 at 21:09

jaczes

1,366
2
8
16

is it possible to put if/else condition on a mysql query? sorry for the dumb question, but is it? – hearmeroar Sep 11 '13 at 22:13
in SELECT only IF or CASE... no IF/ELSE. I was suggesting IF/ELSE in case of stored procs. – jaczes Sep 11 '13 at 22:26

score 0 · Accepted Answer · answered Sep 11 '13 at 22:30

No, it's not possible, in the context of a single SQL statement.

It is possible to combine and INSERT and UPDATE action into a single statement. The INSERT ... ON DUPLICATE KEY UPDATE statement will basically attempt to INSERT a row, and if that insert results in a "duplicate key" exception, the UPDATE action will be performed instead.

But in terms of a testing some general condition with a SELECT statement, and then running an INSERT or UPDATE depending on the result of the query, the answer is no, MySQL does not have any single statement syntax to support that.

The INSERT...ON DUPLICATE KEY UPDATE worked just fine :) THANKS! — hearmeroar, Sep 11 '13 at 22:52

Combine Insert, Update and Select in MySQL

2 Answers2