题解 | #批量插入数据#
批量插入数据
http://www.nowcoder.com/practice/51c12cea6a97468da149c04b7ecf362e
insert into actor
values (1,'PENELOPE','GUINESS','2006-02-15 12:34:33'),(2,'NICK','WAHLBERG','2006-02-15 12:34:33');
不指定列,批量插入行数据:insert into 表名 values(行1字符1,行1字符2…),(行2字符1,行2字符2)