如何获取表中某字段的类型？sql语句

Question

如何获取表中某字段的类型？sql语句

Answer 1

select COLUMN_NAME,DATA_TYPE
from information_schema.COLUMNS
where TABLE_SCHEMA='db1'
and TABLE_NAME='xxx'

Answer 2

select  DATA_TYPE from information_schema.COLUMNS where TABLE_SCHEMA='dbname'
and TABLE_NAME='tablename'
 and column_name = '要查的字段名'