How I can get enum data type in Mysql?

Question

I want to get all enum data type from Mysql database. remember a thing that my table have no data. I read some other post but they have not specific answer as I want. Please someone can help me.

possible duplicate of [How can I get enum possible values in a MySQL database?](http://stackoverflow.com/questions/2350052/how-can-i-get-enum-possible-values-in-a-mysql-database) — Haim Evgi, Mar 05 '12 at 07:22
Possible duplicate of [How can I get enum possible values in a MySQL database?](https://stackoverflow.com/questions/2350052/how-can-i-get-enum-possible-values-in-a-mysql-database) — Brian Tompsett - 汤莱恩, May 08 '18 at 06:28

score 0 · Answer 1 · edited Mar 05 '12 at 09:28

0

I do so:

SELECT DISTINCT(data_type) FROM information_schema.COLUMNSWHERE table_schema =<Your database>

INFORMATION_SCHEMA Tables

edited Mar 05 '12 at 09:28

DIF

2,470
6
35
49

answered Mar 05 '12 at 07:37

bboybit

26
1

score 0 · Answer 2 · answered Mar 05 '12 at 07:39

Try this query to get all ENUM values -

SELECT
  TRIM(TRAILING ')' FROM TRIM(LEADING '(' FROM TRIM(LEADING 'enum' FROM column_type))) enun_values
FROM
  information_schema.`COLUMNS`
WHERE
  TABLE_SCHEMA = 'db_name' AND
  TABLE_NAME = 'table_name' AND
  COLUMN_NAME = 'col_name';

How I can get enum data type in Mysql?

2 Answers2