数据库SQL实战题：批量插入数据（教程）

对于表actor批量插入如下数据

create table if not exists actor (

actor_id smallint(5) not null primary key,

first_name varchar(45) not null,

last_name varchar(45) not null,

last_update timestamp not null default (datetime(‘now’,’localtime’)))

actor_id first_name last_name last_update

1 penelope guiness 2006-02-15 12:34:33

2 nick wahlberg 2006-02-15 12:34:33

注意批量插入的写法

insert into 表名
values (*,*,*),(*,*,*).....;

insert into actor
values(1,'penelope','guiness','2006-02-15 12:34:33'),
      (2,'nick','wahlberg','2006-02-15 12:34:33');