/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

1 vote190 views1 answer
Tsconfig.json, Typescript
TypeScript
0 vote177 views1 answer
Queryselectorall of multiple tags
TypeScript
27 votes389 views3 answers
Styled components in react
TypeScript
6 votes197 views4 answers
Data
TypeScript
11 votes183 views1 answer
Remove dots from ul li
TypeScript
0 vote192 views1 answer
Ts new example
TypeScript
20 votes212 views10 answers
Nodemon
TypeScript
0 vote191 views1 answer
C code for insrting elements in set
TypeScript
0 vote204 views1 answer
Typescript disable next line
TypeScript
0 vote236 views3 answers
How to get particular key value from array of objects in javascrip
TypeScript

Share