SELECT column_name,
column_comment FROM information_schema.columns
WHERE table_schema ='database_name'
AND table_name = 'onetable'
MySQL:获得数据库表的列名和注释 [注释]
最新推荐文章于 2022-06-09 12:10:38 发布
SELECT column_name,
column_comment FROM information_schema.columns
WHERE table_schema ='database_name'
AND table_name = 'onetable'