34,837
社区成员
发帖
与我相关
我的任务
分享如何用insert批量添加数据？
如何批量添加数据？
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')
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')
...全文
请发表友善的回复…
发表回复
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
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
