mysql 查询某张表的字段

use information_schema;
select column_name,COLUMN_COMMENT,DATA_TYPE
from information_schema.columns where table_schema ='init(schema的名字)'  
and table_name = 't_bc_belongperson(表名)';