通过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';
永远年轻,永远热情洋溢!
show create table xm_fdd_contract \G
select count(*) TABLE_SCHEMA from information_schema.COLUMNS where TABLE_SCHEMA='xmebank_dev_new' and table_name='xm_cater';
One thought on “Mysql优化总结”