数据库表基础信息查询

select column_name AS 字段名,COLUMN_type as 数据类型, is_nullable AS is_null,column_comment as 注释 from information_schema.columns where table_schema ='数据库名' and table_name = '表名' ;