mysql常用

xiaoxiao2021-02-28  101

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' ;

转载请注明原文地址: https://www.6miu.com/read-17928.html

最新回复(0)