Mysql. INSERT, UPDATE and WHERE

Question

I'm needing to create a query that update if the some know value exists or create a register if not.

I tried some variations like this below, but I can't put it to work.

How can I do this?

Attemp:

UPDATE OR INSERT
    mytable
SET
    attribute1 = 'value1',
    attribute2 = 'value2',
    attribute3 = 'some known value'
WHERE
    attribute3 = 'some known value'

It's called an "upsert". See: http://stackoverflow.com/questions/1218905/how-do-i-update-if-exists-insert-if-not-aka-upsert-or-merge-in-mysql/1218909#1218909 — Tom, May 15 '13 at 17:39
Are you looking for an [upsert](http://dev.mysql.com/doc/refman/5.1/en/insert-on-duplicate.html)? — Mike Christensen, May 15 '13 at 17:41

score 1 · Answer 1 · answered May 15 '13 at 17:45

@GarouDan your passing only for update query no insert query use below code like this.. first find is there any record with attribute3='some known value'..for that use like this..

declare xattribute text;
select attribute3 into xsttribute where attribute3 = 'some known value'
if found
UPDATE  mytable
SET
    attribute1 = 'value1',
    attribute2 = 'value2',
    attribute3 = 'some known value'
WHERE
    attribute3 = 'some known value'
else
 insert into mytable(attribute1 ,attribute3 ,attribute3 ) values (value1,value2,some known value)

score 0 · Answer 2 · answered May 15 '13 at 17:40

0

Perhaps the MySQL command REPLACE is what you are looking for. An example:

replace into cars (color,crashed) values ('black',0);

answered May 15 '13 at 17:40

mogul

4,441
1
18
22

score 0 · Answer 3 · answered May 15 '13 at 18:42

0

You should use mysql's INSERT...ON DUPLICATE KEY UPDATE syntax:

http://dev.mysql.com/doc/refman/5.5/en/insert-on-duplicate.html

answered May 15 '13 at 18:42

Cargo23

3,064
16
25

Mysql. INSERT, UPDATE and WHERE

3 Answers3