/TypeScript/MySQL update if exists else insert

MySQL update if exists else insert

Mysql insert exists update

INSERT INTO table (column_list)
VALUES (value_list)
ON DUPLICATE KEY UPDATE
   c1 = v1, 
   c2 = v2,
   ...;

3

Source: mysqltutorial.org

MySQL update if exists else insert

INSERT INTO tableName(id, NAME, score)
VALUES(1, "Fadl", 285)
ON DUPLICATE KEY
UPDATE NAME = "Fadl", score = 285

0

Source: stackoverflow.com

Similar codes

0 vote270 views5 answers
[email protected]
TypeScript
5 votes271 views2 answers
Copy array typescript
TypeScript
0 vote231 views1 answer
C# compare two objects for changes
TypeScript
6 votes241 views2 answers
TYPESCript props class component
TypeScript
0 vote247 views1 answer
Subscription' is deprecated
TypeScript
1 vote274 views1 answer
Mongodb array size greater than
TypeScript
0 vote233 views1 answer
Error on indexing the object in ts
TypeScript
0 vote217 views1 answer
Form control adding disabled and validators
TypeScript
1 vote248 views2 answers
Dart clone list
TypeScript
2 votes232 views1 answer
Rxjs promise to observable
TypeScript

Share