insert 批量插入 

insert into persons 
(id_p, lastname , firstName, city )
values
(200,'haha' , 'deng' , 'shenzhen'),
(201,'haha2' , 'deng' , 'GD'),
(202,'haha3' , 'deng' , 'Beijing');
转载自https://www.gxlcms.com/mysql-377244.html
posted @ 2022-06-27 17:50  wyuioahxvm  阅读(83)  评论(0)  编辑  收藏  举报