mysql 查询有多少条记录的表有哪些

-- 查看数据量区间的表,下面的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 ,(
select TABLE_NAME from information_schema.tables where TABLE_SCHEMA='test' and table_rows>=50 and table_rows<=500  order by table_rows desc
) b where a.table_name = b.table_name

-- 查看test数据库大小

select concat(round(sum(data_length/1024/1024),2),'MB') as data from information_schema.tables where table_schema='test';

-- 查询test 数据库中哪些表包含name字段
select table_schema,table_name from information_schema.columns where column_name = 'name' and TABLE_SCHEMA ='test'

-- mysql 运行超大脚本可能需要用到的sql语句

show VARIABLES like '%max_allowed_packet%';

set global max_allowed_packet = 1024*1024*1024;

SHOW VARIABLES WHERE Variable_name LIKE 'character%' OR Variable_name LIKE 'collation%';