如何用insert批量添加数据？

[mudsong]

如何批量添加数据？
INSERT INTO Users (UserName,Gender,Career,Birthday,Addr,Tel,Email)
VALUES ('cc',0,'abc','01-01','abc','010-88888888','[e-mail]')
('dd',0,'abc','01-01','abc','010-88888888','[e-mail]')
('ee',0,'abc','01-01','abc','010-88888888','[e-mail]')
('ff',0,'abc','01-01','abc','010-88888888','[e-mail]')
('gg',0,'abc','01-01','abc','010-88888888','[e-mail]')

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

[lynx1111]

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

[zjcxc]

同意楼上.

[dlpseeyou]

同意楼上~~~~