SELECT column_name,column_comment,data_type FROM information_schema.columns WHERE table_name='表名' AND table_schema = "数据库名";
转载于:https://www.cnblogs.com/yangcclg/p/5209267.html
SELECT column_name,column_comment,data_type FROM information_schema.columns WHERE table_name='表名' AND table_schema = "数据库名";
转载于:https://www.cnblogs.com/yangcclg/p/5209267.html