mysql常用语句

统计数据库表字段：select count(*) from information_schema.COLUMNS where TABLE_SCHEMA='数据库名' and table_name='表名'