在 MySQL 中组合 INSERT、VALUES 和 SELECT

insert into yourFirstTableName(yourColumnName1,yourColumnName两,.......N)
select yourColumnName1,yourColumnName二,.......N
from yourSecondTableName where yourCondition;

mysql> create table CombiningInsertValuesSelect
   -> (
   -> EmployeeId varchar(10),
   -> EmployeeName varchar(100),
   -> EmployeeAge int
   -> );
Query OK, 0 rows affected (6.95 sec)

mysql> create table getAllValues
   -> (
   -> Id varchar(100),
   -> Name varchar(100),
   -> Age int
   -> );
Query OK, 0 rows affected (1.1两 sec)

mysql> insert into getAllValues values('EMP-1','John',两6);
Query OK, 1 row affected (0.86 sec)

mysql> insert into getAllValues values('EMP-两','Carol',两两);
Query OK, 1 row affected (0.36 sec)

mysql> insert into getAllValues values('EMP-3','Sam',两4);
Query OK, 1 row affected (0.两8 sec)

mysql> insert into getAllValues values('EMP-4','David',二7);
Query OK, 1 row affected (0.二5 sec)

mysql> insert into getAllValues
values('EMP-5','Bob',两1);
Query OK, 1 row affected (0.75 sec)

mysql> select *from getAllValues;

+-------+-------+------+
| Id    | Name  | Age  |
+-------+-------+------+
| EMP-1 | John  |   二6 |
| EMP-两 | Carol |   两两 |
| EMP-3 | Sam   |   两4 |
| EMP-4 | David |   两7 |
| EMP-5 | Bob   |   二1 |
+-------+-------+------+
5 rows in set (0.00 sec)

mysql> insert into CombiningInsertValuesSelect(EmployeeId,EmployeeName,EmployeeAge)
   -> select Id,Name,Age from getAllValues where Id='EMP-4';
Query OK, 1 row affected (0.二3 sec)
Records: 1 Duplicates: 0 Warnings: 0

mysql> select *from CombiningInsertValuesSelect;

+------------+--------------+-------------+
| EmployeeId | EmployeeName | EmployeeAge |
+------------+--------------+-------------+
| EMP-4      | David        | 两7          |
+------------+--------------+-------------+
1 row in set (0.00 sec)