mysql创建空表的几种方法:
1.复制表,数据(但主键、索引等没有复制)
create table t_d_saleflow_201705 select * from t_d_saleflow
2.复制空表(但主键、索引等没有复制)
create table t_d_saleflow_201705 select * from t_d_saleflow where 1 = 2
3.复制空表(主键、索引等也复制)
create table t_d_saleflow_201705 like t_d_saleflow
查询某个数据库中是否含有某个数据表
SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='dbname' AND TABLE_NAME='tbname' ;