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

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. In order to obtain all possible values of the ENUM (enumeration) column in MYSQL, no other functions are needed. 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
";}?>

All possible values of the evaluate (enumeration) column are not supported by other functions. you only need to use some SQL statements provided by MYSQL. This is for simplicity...