题解 | #批量插入数据#

1.分析
mysql批量插入，就是一个insert后面跟两个values。

2.代码
#INSERT INTO actor (actor_id, first_name, last_name, last_update)
#VALUES (1, "PENELOPE", "GUINESS", "2006-02-15 12:34:33");
#INSERT INTO actor (actor_id, first_name, last_name, last_update)
#VALUES (2, "NICK", "WAHLBERG", "2006-02-15 12:34:33");

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');