mysql常用语句
1.查询某个数据库中表的数量:
SELECT COUNT( * ) FROM information_schema.tables WHERE TABLE_SCHEMA = 'your_db_name'
2.是否支持分区:
show variables like '%partition%'
3.查看表的定义:
show create table table_name
posted on 2018-07-04 14:17 shammgod_code 阅读(73) 评论(0) 编辑 收藏 举报