Mysql优化总结

通过sql显示表结构

show create table xm_fdd_contract \G

通过sql显示一个表有几个字段

select count(*) TABLE_SCHEMA from information_schema.COLUMNS where TABLE_SCHEMA='xmebank_dev_new' and table_name='xm_cater';