Tip: Get all possible values ​​of ENUM (enumeration) column in MYSQL_PHP tutorial

In fact, there is no need for other functions to support this. You only need to use some SQL statements provided by MYSQL.
For the sake of simplicity, here we take the MYSQL system table USER as an example to retrieve all possible values ​​of the SELECT_PRIV column.
Method: SHOW COLUMNS FROM table_name LIKE enum_column_name
　The lowercase part needs to be changed according to your situation.
Program:
//By SonyMusic(sonymusic@163.com)
//HomePage(phpcode.yeah.net)
$connect_hostname="localhost";
$dbname="mysql";
$connect_username = "root";
$connect_pass ="";
$connect_id = mysql_connect($connect_hostname, $connect_username, $connect_pass);
mysql_select_db ($dbname);

$query="show columns from user like 'select_priv'";
$result=mysql_db_query($dbname,$query);
$enum=mysql_result($result ,0,"type");
echo $enum."
";
$enum_arr=explode("(",$enum);
$enum=$enum_arr[1];
$enum_arr=explode(")",$enum);
$enum=$enum_arr[0];
$enum_arr=explode(",",$enum);
for($ i=0;$i echo $enum_arr[$i]."
";
}
?>

http://www.bkjia.com/PHPjc/631073.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/631073.htmlTechArticleIn fact, there is no need for other functions to support it. You only need to use some SQL statements provided by MYSQL. . For the sake of simplicity, here we take the MYSQL system table USER as an example and take out...