mysql语句之INSERT INTO批量插入数据案例

mysql语句之INSERT INTO批量插入数据：

INSERT INTO dede_archives (title, source, litpic, voteid)
VALUES
('1','《皕宋楼藏书志》1 - 潜园总集_陆心源归安陆氏P1', '1320530', '/img/a01029001_001', 1),
('2','《皕宋楼藏书志》2 - 潜园总集_陆心源归安陆氏P2', '1320528', '/img/a01029002_001', 1);
('3','《皕宋楼藏书志》2 - 潜园总集_陆心源归安陆氏P3', '1320528', '/img/a01029003_001', 1);

INSERT INTO dede_archives (title, source, litpic, voteid)

VALUES

('1','《皕宋楼藏书志》1 - 潜园总集_陆心源归安陆氏P1', '1320530', '/img/a01029001_001', 1),

('2','《皕宋楼藏书志》2 - 潜园总集_陆心源归安陆氏P2', '1320528', '/img/a01029002_001', 1);

('3','《皕宋楼藏书志》2 - 潜园总集_陆心源归安陆氏P3', '1320528', '/img/a01029003_001', 1);

也可以合并成一行

INSERT INTO dede_archives (id,title,source,litpic,voteid) VALUES ('1','《皕宋楼藏书志1》','1320530','/60img/a01029001','1'),('2','《皕宋楼藏书志2》','1320528','/60img/a01029002_001','1');

1	INSERT INTO dede_archives (id,title,source,litpic,voteid) VALUES ('1','《皕宋楼藏书志1》','1320530','/60img/a01029001','1'),('2','《皕宋楼藏书志2》','1320528','/60img/a01029002_001','1');