在mysql中select_在MySQL中插入Select查询

对于使用SELECT查询插入，语法如下-insert into yourTableName(yourColumnName1,yourColumnName2,yourColumnName3,...N) select yourValue1,yourValue2,yourValue3,......N;

让我们首先创建一个表-mysql> create table DemoTable1603

-> (

-> StudentId int,

-> StudentName varchar(20),

-> StudentMarks int

-> );

使用插入命令在表中插入一些记录-mysql> insert into DemoTable1603(StudentId,StudentName,StudentMarks) select 101,'John',45;

Records: 1  Duplicates: 0  Warnings: 0

mysql> insert into DemoTable1603(StudentId,StudentName,StudentMarks) select 102,'Adam',76;

Records: 1  Duplicates: 0  Warnings: 0

mysql> insert into DemoTable1603(StudentId,StudentName,StudentMarks) select 103,'Bob',67;

Records: 1  Duplicates: 0  Warnings: 0

使用select语句显示表中的所有记录-mysql> select * from DemoTable1603;

这将产生以下输出-+-----------+-------------+--------------+

| StudentId | StudentName | StudentMarks |

+-----------+-------------+--------------+

|       101 | John        |           45 |

|       102 | Adam        |           76 |

|       103 | Bob         |           67 |

+-----------+-------------+--------------+

3 rows in set (0.00 sec)