查看mysql多个表的行数

select * from tables WHERE TABLE_NAME in ('comp_game_calc_start','rewat','patport','rent','hom') and TABLE_SCHEMA='abc' \G;

转载于:https://blog.51cto.com/victor2016/1891012