1.先查询表结构 desc user; 再统计行数即可 select found_rows(); 2.通过查询information_schema表 select count(1) from information_schema.`COLUMNS` where TABLE_SCHEMA = "mysql" and TABLE_NAME="user";