MySQL if value exists select else insert

Question

What is the most efficient mysql query to SELECT from a table IF a value already exists ELSE INSERT?

I have already tried several options but can't find something that works for me.

score 1 · Answer 1 · edited May 23 '17 at 11:59

1

I'm new to Stackoverflow and dont know how to tag a question as duplicate.

But i think there is a really similar question with plenty of answers. Give a look here

[Possible solution]

You could insert if it not exists and then select it.

INSERT INTO Test(Key_Value , Name , ...) VALUES(@Key_Value ,@Name,..) WHERE NOT EXISTS (SELECT 1 FROM Test WHERE KeyValue = @KeyValue);

SELECT Name FROM Test WHERE Key_Value = @Key_Value

edited May 23 '17 at 11:59

Community

1
1

answered Mar 11 '15 at 15:24

Enpi

281
1
9

That answer is for MS SQL so doesn't solve my issue. – Ben Gordon Mar 11 '15 at 15:31
It's really similar actually. I will edit my answer a bit. – Enpi Mar 11 '15 at 15:36

MySQL if value exists select else insert

1 Answers1