select column_name,column_comment,data_type
from information_schema.columns
where table_name='表名' and table_schema='数据库名'
mysql 学习笔记:查看字段类别
最新推荐文章于 2023-11-20 17:34:09 发布
select column_name,column_comment,data_type
from information_schema.columns
where table_name='表名' and table_schema='数据库名'