创建临时表
https://www.runoob.com/mysql/mysql-temporary-tables.html
CREATE TEMPORARY TABLE 临时表名 AS
(
SELECT * FROM 旧的表名
LIMIT 0,10000
);
1
2
3
4
5
2
3
4
5
编辑 (opens new window)
上次更新: 2021/10/11, 12:43:58
https://www.runoob.com/mysql/mysql-temporary-tables.html
CREATE TEMPORARY TABLE 临时表名 AS
(
SELECT * FROM 旧的表名
LIMIT 0,10000
);