mysql系统表为INFORMATION_SCHEMA.TABLES 可以根据系统表进行多表数据总数查询 select sum(TABLE_ROWS) from INFORMATION_SCHEMA.TABLES where TABLE_NAME like 'tbl_WifiFF%' AND table_schema = 'location';