从我的previous question来看,这是我接受的解决方案:
INSERT IGNORE INTO table_name
SET name = 'phill',
value = 'person',
id = 12345;但我也想知道我是否可以像这样得到多个值
INSERT IGNORE INTO table_name
SET (name = 'phill', value = 'person', id = 12345),
(name = 'bob', value = 'person', id = 12346);发布于 2010-02-09 03:33:57
INSERT IGNORE INTO table_name(name,value,id) VALUES
('phill','person',12345),('bob','person',12346)https://stackoverflow.com/questions/2224253
复制相似问题