摘要： select column_name AS 字段名,COLUMN_type as 数据类型, is_nullable AS is_null,column_comment as 注释 from information_schema.columns where table_schema ='数据库名' 阅读全文