如何用insert批量添加数据？

mudsong 2003-12-12 03:51:19

如何批量添加数据？
INSERT INTO Users (UserName,Gender,Career,Birthday,Addr,Tel,Email)
VALUES ('cc',0,'abc','01-01','abc','010-88888888','root@163.com')
('dd',0,'abc','01-01','abc','010-88888888','root@163.com')
('ee',0,'abc','01-01','abc','010-88888888','root@163.com')
('ff',0,'abc','01-01','abc','010-88888888','root@163.com')
('gg',0,'abc','01-01','abc','010-88888888','root@163.com')

这样不行，难道一定要这样？
INSERT INTO Users (UserName,Gender,Career,Birthday,Addr,Tel,Email)
VALUES ('aa',0,'abc','01-01','abc','010-88888888','root@163.com')
INSERT INTO Users (UserName,Gender,Career,Birthday,Addr,Tel,Email)
VALUES ('bb',0,'abc','01-01','abc','010-88888888','root@163.com')
INSERT INTO Users (UserName,Gender,Career,Birthday,Addr,Tel,Email)
VALUES ('cc',0,'abc','01-01','abc','010-88888888','root@163.com')
INSERT INTO Users (UserName,Gender,Career,Birthday,Addr,Tel,Email)
VALUES ('dd',0,'abc','01-01','abc','010-88888888','root@163.com')
INSERT INTO Users (UserName,Gender,Career,Birthday,Addr,Tel,Email)
VALUES ('ee',0,'abc','01-01','abc','010-88888888','root@163.com')

...全文

1035 3 打赏收藏转发到动态举报

写回复

用AI写文章

3 条回复

切换为时间正序

请发表友善的回复…

发表回复

dlpseeyou 2003-12-12

打赏
举报

同意楼上~~~~

zjcxc 元老 2003-12-12

打赏
举报

同意楼上.

lynx1111 2003-12-12

打赏
举报

create table 表一(sGroundNo char(5),iIndex int,iFactorClassSn int)
insert 表一 select 'zd001', 100, 1
union all select 'zd001', 100 , 2
union all select 'zd001', 99 , 3
union all select 'zd001', 100 , 4
union all select 'zd001', 100 , 5
union all select 'zd001', 100 , 6
union all select 'zd001', 100 , 9
union all select 'zd001', 100 , 12
union all select 'zd001', 100 , 16
union all select 'zd001', 100, 14
union all select 'zd001', 100 , 15
union all select 'zd001', 100 , 17