sql - 从选择命令创建一个新表

Question

假设我有这样的命令:

select name, age, haircolor from people where shoesize > 10;

有没有一种方法可以根据该命令返回的内容创建一个新表？我想将该命令的输出通过管道传输到一个新表中。

含义:

mysql> show tables; 
+-----------------+
| Tables_in_db1   |
+-----------------+
| people          |
+-----------------+
1 rows in set (0.00 sec)

mysql> CREATE TABLE FROM "select name, age, haircolor from people where shoesize > 10;";
..?

mysql> show tables; 
+-----------------+
| Tables_in_db1   |
+-----------------+
| people          |
| NEW TABLE       |
+-----------------+
1 rows in set (0.00 sec)

Answer 1

是的，CREATE TABLE语法最后支持一个选项 SELECT 语句，它可以像这样简单:

 CREATE TABLE foo
 SELECT bar FROM xyz;