C# MySql if record exists update else insert?

Question

lets say i have a column uniqueID that had '1' in it. What I want to do is only update called phonenumber total. If it doesn't exist then insert. Is 'REPLACE into table' what I am looking for?

INSERT ... ON DUPLICATE KEY UPDATE Syntax

user222427
– user222427

2011-03-07 21:49:21 +00:00
Commented Mar 7, 2011 at 21:49 — user222427
– user222427, Commented Mar 7, 2011 at 21:49

sisve · Accepted Answer · 2011-03-07 21:24:22Z

4

This is called an 'upsert' (UPdate/inSERT).

Examples at How to write flexible INSERT and UPDATE statements in MySQL

answered Mar 7, 2011 at 21:24

sisve

19.8k3 gold badges55 silver badges96 bronze badges

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

1 Comment

user222427 Over a year ago

I like it but it will slow everything down a lot, is there a way to say if ROW exists blah or else?

Bengie · Accepted Answer · 2011-03-07 22:08:52Z

0

There is an SQL standard for this called "MERGE". Some recent version of Oracle and MSSQL2008+ support this. Not sure about MySQL

answered Mar 7, 2011 at 22:08

Bengie

1,0455 silver badges10 bronze badges

Collectives™ on Stack Overflow

C# MySql if record exists update else insert?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related