标签 创建 下的文章

MySQL将查询结果创建为新表

MySQL 将查询结果创建为新表。 语法为: CREATE TABLE newTableName AS SELECT * FROM oldTable; 举例: CREATE TABLE log20161102 AS SELECT * FROM `log201611` WHERE app...