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')
MySQL批量插入数据,就是用insert into函数,
列名称。不用加双引号。数据内容分几列,加双引号
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')
MySQL批量插入数据,就是用insert into函数,
列名称。不用加双引号。数据内容分几列,加双引号