标签 创建 下的文章

MySQL将查询结果创建为新表

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