题解 | #批量插入数据#
批量插入数据
https://www.nowcoder.com/practice/51c12cea6a97468da149c04b7ecf362e
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 表名(列1,列2,列3,...)
values(值1,值2,值3,...),
(值1,值2,值3,...)