1.创建表的同时插入其他表的数据
CREATE TABLE table_name
SELECT ...
FROM ...
[...]
例:
CREATE TABLE tabl_memory ENGINE = MEMORY
SELECT city_id, city, country_id
FROM city
GROUP BY city_id
本文共 305 字，大约阅读时间需要 1 分钟。
1.创建表的同时插入其他表的数据
CREATE TABLE table_name
SELECT ...
FROM ...
[...]
例:
CREATE TABLE tabl_memory ENGINE = MEMORY
SELECT city_id, city, country_id
FROM city
GROUP BY city_id
转载于:https://www.cnblogs.com/microcat/p/6603477.html