题解 | #批量插入数据#
INSERT INTO actor(actor_id, first_name, last_name, last_update) VALUES(1,'PENELOPE','GUINESS','2006-02-15 12:34:33'), (2,'NICK','WAHLBERG','2006-02-15 12:34:33');
思路:
批量插入数据的方法
INSERT INTO (字段名) VALUES(值),(),()
INSERT INTO actor(actor_id, first_name, last_name, last_update) VALUES(1,'PENELOPE','GUINESS','2006-02-15 12:34:33'), (2,'NICK','WAHLBERG','2006-02-15 12:34:33');
思路:
批量插入数据的方法
INSERT INTO (字段名) VALUES(值),(),()
相关推荐