mysql 的information_schema数据表中有很多内容。
1. 查找字段名的类型
select COLUMN_NAME,DATA_TYPE from information_schema.COLUMNS
where TABLE_SCHEMA='ZTE'
and TABLE_NAME='terminal_data_file'
select COLUMN_NAME,DATA_TYPE from information_schema.COLUMNS
where TABLE_SCHEMA='ZTE'
and TABLE_NAME='terminal_data_file'