如何用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')