如何在mysqlworkbench的表的某一字段类型是enum

Question

如题所述

Answer 1

1
2
3

SELECT COLUMN_TYPE FROM information_schema.COLUMNS where TABLE_SCHEMA = 'db' and TABLE_NAME = 'table' and COLUMN_NAME = 'table';

/*库名 表名 字段名自己改改*/本回答被提问者采纳