求sql怎么一次用insert 添加多条数据

Question

如题所述

Answer 1

insert into persons
(id_p, lastname , firstName, city )
values
(200,'haha' , 'deng' , 'shenzhen'),
(201,'haha2' , 'deng' , 'GD'),
(202,'haha3' , 'deng' , 'Beijing');本回答被提问者采纳

Answer 2

insert into table select ...