Insert SQL data into row with same id?

Question

Is there a SQL command for inserting data into a row where the id = the table id, and if it doesnt exists then insert into a new row?

Something like: ('INSERT INTO USERS IF EXISTS WHERE userID=ID')

Do an internet search for UPSERT. Include the brand of RDBMS you are using in your search. — Robert Harvey, May 23 '13 at 19:36
http://stackoverflow.com/questions/1361340/how-to-insert-if-not-exists-in-mysql — τεκ, May 23 '13 at 19:36

score 1 · Answer 1 · answered May 23 '13 at 19:40

1

I understood your question like this

INSERT INTO table1(value1, value2) 
SELECT value1, value2 FROM table2where table2.userID =  Id

answered May 23 '13 at 19:40

Nope. That's not what he wants. – Robert Harvey May 23 '13 at 19:48
then he has to use sql case statement – Narayan Yerrabachu May 23 '13 at 19:56
Try doing a Google Search for UPSERT SQL. – Robert Harvey May 23 '13 at 19:59
Does upsert works in very database?I mean like db2 or someother databases – Narayan Yerrabachu May 23 '13 at 20:02
Every database does it a bit differently. Those that support the SQL 2003 standard and above can use [MERGE](http://en.wikipedia.org/wiki/Merge_(SQL)). – Robert Harvey May 23 '13 at 20:03

score 1 · Answer 2 · answered May 23 '13 at 19:49

1

You can write something simple like this:

IF (SELECT COUNT(t.ID) FROM t WHERE t.ID=@id)=1
    UPDATE
ELSE
    INSERT

answered May 23 '13 at 19:49

2 Answers2