INSERT INTO t_user ( id, sex )
VALUES ( '1', '男' ) ( '2', '男' ) ( '3', '男' )
ON DUPLICATE KEY UPDATE sex = VALUES(sex)
mysql insert ON DUPLICATE KEY
最新推荐文章于 2024-03-15 20:56:06 发布
INSERT INTO t_user ( id, sex )
VALUES ( '1', '男' ) ( '2', '男' ) ( '3', '男' )
ON DUPLICATE KEY UPDATE sex = VALUES(sex)