update multi rows using only one sql; 一句 sql update 多行数据

来源：互联网发布：航天金税官网开票软件编辑：程序博客网时间：2024/06/10 08:05

mysql> select * from states;+----+---------+------------+| id | state   | population |+----+---------+------------+|  1 | Alabama |    4822026 ||  2 | bbb     |      33444 ||  3 | Alabama |    4822024 ||  4 | ccc     |         44 ||  5 | ddd     |          5 |+----+---------+------------+5 rows in set (0.00 sec)mysql> INSERT INTO states (id, population) VALUES (4, 444), (5, 555) ON DUPLICATE KEY UPDATE id=values(id), population=values(population);Query OK, 4 rows affected (0.00 sec)Records: 2  Duplicates: 2  Warnings: 0mysql> select * from states;                                                                                                      +----+---------+------------+| id | state   | population |+----+---------+------------+|  1 | Alabama |    4822026 ||  2 | bbb     |      33444 ||  3 | Alabama |    4822024 ||  4 | ccc     |        444 ||  5 | ddd     |        555 |+----+---------+------------+

阅读全文

0 0