mysql 字段操作

1、获取mysql支持的字段类型
select DISTINCT DATA_TYPE from information_schema.COLUMNS

2、获取某表的字段名及字段类型
select COLUMN_NAME , DATA_TYPE from information_schema.COLUMNS where table_name = ‘表名’;

3、获取指定数据库的BASE TYPE 的表名
SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA=”数据库名”AND TABLE_TYPE = “BASE TABLE”