1.select column_name,data_type,character_maximum_length
from information_schema.columns
where table_name='TableName' and column_name='ColName'
2.information_schema.columns是系统视图,记录表的字段的相关信息。
1.select column_name,data_type,character_maximum_length
from information_schema.columns
where table_name='TableName' and column_name='ColName'
2.information_schema.columns是系统视图,记录表的字段的相关信息。