Tips: obtain all possible values of the ENUM enumeration column in MYSQL.

Obtaining all possible values of the ENUM (enumeration) column in MYSQL does not require any other functions. you only need to use some SQL statements provided by MYSQL. For the sake of simplicity, take the MYSQL system table USER as an example to retrieve all possible values in the SELECT_PRIV column. Method: SHOWCSyntaxHighlighte

Obtaining all possible values of the ENUM (enumeration) column in MYSQL does not require any other functions. you only need to use some SQL statements provided by MYSQL. For the sake of simplicity, take the MYSQL system table USER as an example to retrieve all possible values in the SELECT_PRIV column. Method: show columns from table_name LIKE enum_column_name the lower-case section needs to be changed according to your situation. Program: "; $ Enum_arr = explode (" (", $ enum); $ enum = $ enum_arr [1]; $ enum_arr = explode (") ", $ enum ); $ enum = $ enum_arr [0]; $ enum_arr = explode (",", $ enum); for ($ I = 0; $ I
";}?>