Mysql 读取 表结构

select `TABLE_NAME` from `INFORMATION_SCHEMA`.`TABLES` where `TABLE_SCHEMA` = 'truck_development' and `TABLE_TYPE` = 'BASE TABLE'
select * from information_schema.tables where table_schema = 'truck_development';
select * from information_schema.columns
select data_type, count(*) from information_schema.columns where table_schema = 'truck_development' group by data_type