MySQL query table field name, field type

select column_name,column_comment,data_type

from information_schema.columns

where table_name='tableName' and table_schema='databaseName'