题解 | #批量插入数据#

插入一条数据,可以写列名也可以不写列名

insert into actor(actor_id,first_name,last_name,last_update)
VALUES (2,'NICK','WAHLBERG','2006-02-15 12:34:33');

insert into actor VALUES(1,'PENELOPE','GUINESS','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');