APP 題目已經(jīng)先執(zhí)行了如下語句:
drop?table?if?exists?actor;
CREATE?TABLE?actor?(
???actor_id??smallint(5)??NOT?NULL?PRIMARY?KEY,
???first_name??varchar(45)?NOT?NULL,
???last_name??varchar(45)?NOT?NULL,
???last_update??DATETIME?NOT?NULL)
請你對于表actor批量插入如下數(shù)據(jù)(不能有2條insert語句哦!)
| 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 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')