查看一个表有多少列

select count(*)
from information_schema.COLUMNS
where TABLE_SCHEMA='库名' and table_name='表名'