select count(*)
from information_schema.COLUMNS
from information_schema.COLUMNS
where TABLE_SCHEMA='ddd' and table_name='ttt'
//注:ddd是数据库名称 ,ttt是数据表名称
where TABLE_SCHEMA='ddd' and table_name='ttt'
//注:ddd是数据库名称 ,ttt是数据表名称