此文为SQL笔记,若能帮助到你,不胜荣幸!
INSERT INTO `table`(
`pk`,
`col_1`,
`col_2`,
`col_3`,
`col_4`
)
VALUES
(
'1',
'val_1',
'val_2',
'val_3',
'val_4'
)ON DUPLICATE KEY UPDATE `col_1` = 'val_1',
`col_2` = 'val_2',
`col_3` = 'val_3',
`col_4` = 'val_4'