可以在mysql的 infomation_schema库中的columns表中查总列数。SELECT count(COLUMN_NAME) as num FROM `COLUMNS` where TABLE_NAME='pj_ex

统计所有记录的数量：SELECT COUNT(*) FROM table_name统计某列的数量：SELECT COUNT(column_name) FROM table_namewhere 条件select proxxx,count(lo