qq_34596251的博客

-- 查看数据量区间的表,下面的sql查询test数据库中 包含列名为name 且 数据大于50条 小于 500条的表有哪些 select a.* from ( SELECT DISTINCT TABLE_NAME FROM information_schema.COLUMNS WHERE COLUMN_NAME = 'name' AND TABLE_SCHEMA='test' ) a ,( s...

转https://blog.youkuaiyun.com/blueheart20/article/details/52385142