Home > Database > Mysql Tutorial > 如何取得MYSQL中ENUM列的全部可能值_MySQL

如何取得MYSQL中ENUM列的全部可能值_MySQL

WBOY
Release: 2016-06-01 13:55:34
Original
748 people have browsed it

这里其实并不需要其它的什么函数来支持,只需要使用MYSQL提供的一些SQL语句就可以了。

  这里为了简单起见,以MYSQL的系统表USER为例,取出SELECT_PRIV这一列的所有可能值。

  方法:SHOW COLUMNS FROM table_name LIKE enum_column_name

  小写的部分需要根据你的情况改变。

  程序: 

  //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");
  网管网bitsCN_com
  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]."
";
  }
  ?>

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template