/SQL/Mysql on duplicate key update get value from values

Mysql on duplicate key update get value from values

Mysql on duplicate key update

INSERT INTO t1 (a,b,c) VALUES (1,2,3)
  ON DUPLICATE KEY UPDATE c=3;
INSERT INTO t1 (a,b,c) VALUES (4,5,6)
  ON DUPLICATE KEY UPDATE c=9;

2

Source: dev.mysql.com

Mysql on duplicate key update get value from values

INSERT INTO `tableName` (`a`,`b`,`c`) VALUES (1,2,3)
ON DUPLICATE KEY UPDATE `a`=VALUES(`a`), `b`=VALUES(`b`), `c`=VALUES(`c`);

0

Source: stackoverflow.com

Similar codes

0 vote346 views1 answer
FIND LOWEST SALARY EARNER IN SQL
SQL
22 votes381 views3 answers
How to join three tables in sql using joins
SQL
0 vote330 views1 answer
How to count with except in psql
SQL
0 vote351 views1 answer
Mysql grouping functions
SQL
0 vote351 views2 answers
How to find sql server agent jobs related to a database
SQL
9 votes371 views3 answers
Pyodbc connect to sql server
SQL
0 vote338 views1 answer
Sql transact create cursor with dynamic tables
SQL
24 votes331 views4 answers
Mssql get all table names
SQL
0 vote374 views1 answer
Python mysql show databases
SQL
4 votes329 views1 answer
SQL order random
SQL

Share