MySQL查询：如何用UNIOn插入？

您也可以“选择”文字值：

mysql> select 'hello', 1;+-------+---+| hello | 1 |+-------+---+| hello | 1 |+-------+---+1 row in set (0.00 sec)

因此，您也可以在

INSERT INTO ... SELECT FROM

UNIOn

INSERT INTO sometable (a, b, c) VALUESSELECt id, name, 5FROM someOtherTableUNIOnSELECt id, alias, 8FROM anotherTable