/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

32 votes163 views10 answers
Translate
TypeScript
0 vote191 views1 answer
Linux Write a command to list all contents of files whose names start by a and end by z
TypeScript
0 vote230 views1 answer
How to get class weights while using keras imagedatagenerator
TypeScript
2 votes169 views10 answers
Javascript
TypeScript
1 vote173 views1 answer
Geting request header in loopback4
TypeScript
-1 vote159 views1 answer
2d array of strings and ints python
TypeScript
1 vote171 views1 answer
Facts aboutdavid oliveira
TypeScript
0 vote167 views1 answer
How to delete a message by its id
TypeScript
1 vote192 views1 answer
Error: Missing "key" prop for element in iterator
TypeScript
4 votes171 views2 answers
Wht we need migrationts in django
TypeScript

Share