Sql-insert A statement to perform multiple data insertions

There are three ways to do this:

1. InSert  into < table name >(column name)Select< column name >from< source table name >

Such as:

INSERT  into  SELECT  sname,saddress,semail from Students This method requires a new table to be built first.

2.

Select (column name)  into < table name >from< source table name >

Such as:

SELECT Students.sname,students.saddress,students.semail  into Tongxunlu  from Students This method SQL auto-Build table

3.

InSert  into < table name >(column name)Select< column name >Union Select < column name >Union ...

Such as:

INSERTSTUDENTS (sname,sgrade,ssex)SELECT 'Zhang can',7,1 UNIONSELECT 'Li Yang',4,0 UNIONSELECT 'Yang Xiao',2,0 UNIONSELECT 'Tang Mei',3,0 UNIONSELECT 'Su Sandong',7,1 UNIONSELECT 'Wang Li',3,1 UNIONSELECT 'Zhang Wei',7,1 UNIONSELECT 'Chen Gang',4,1 UNIONSELECT 'Wang Juan Juan',7,0

Sql-insert A statement to perform multiple data insertions