sql插入多条数据的sql语句
有三种方法:
1.InSert Into <表名>(列名)
Select <列名>
From <源表名>
如:INSERT INTO TongXunLu (姓名,电话,电子邮件)
SELECT SName,SAddress,SEmail
FROM Students 这种方法需要先建好新表.
2.Select (列名)
Into <表名>
From <源表名>
如:SELECT Students.SName,Students.SAddress,Students.SEmail
INTO TongXunLu
FROM Students 这种方法SQL自动建表
3.InSert Into <表名>(列名)
Select <列名> Union
Select <列名> Union
……
如:INSERT STUDENTS (SName,SGrade,SSex)
SELECT \'小敏\',7,1 UNION
SELECT \'小明\',4,0 UNION
SELECT \'小猪\',2,0 UNION
SELECT \'笑话\',3,0 UNION
SELECT \'大小\',7,1 UNION
SELECT \'无二\',3,1 UNION
SELECT \'小伟\',7,1 UNION
SELECT \'小刚\',4,1 UNION
SELECT \'小娟\',7,0
![](https://image.shishitao.com:8440/aHR0cHM6Ly9pbWcyMDIyLmNuYmxvZ3MuY29tL2Jsb2cvMzU2OTUvMjAyMjAxLzM1Njk1LTIwMjIwMTIwMTgzMDM4MDczLTE4MDg2MzE3Ny5qcGc%3D.jpg?w=700&webp=1)