/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

2 votes128 views1 answer
Socketi io client disconnect
TypeScript
2 votes150 views1 answer
Prettier eslint typescript
TypeScript
0 vote144 views1 answer
File reader with promise
TypeScript
4 votes135 views4 answers
Array.prototype.map() expects a return value from arrow function array-callback-return
TypeScript
5 votes137 views2 answers
Merge lists in list python
TypeScript
0 vote175 views1 answer
Get distinct elements in table psql
TypeScript
3 votes144 views1 answer
Whats the binary nmber system
TypeScript
0 vote129 views1 answer
How to read web page in type script
TypeScript
-1 vote144 views1 answer
Nestjs tutorial for beginners
TypeScript
0 vote135 views1 answer
C code for insrting elements in set
TypeScript

Share