SELECT column_type FROM information_schema. COLUMNS WHERE TABLE_SCHEMA = "数据库名" AND DATA_TYPE = ‘enum‘ AND table_name="表明" AND column_name="列名";
获取到的结果
mysql中使用enum,如何获取所有可能的值
原文:https://www.cnblogs.com/zqr99/p/9208341.html