blocks|key|1101719|text|$row+=+db_fetch_object($result);
+++++if($row){
+++++$type+=+$row->Type;
+++++preg_match_all("/'([%5E']%2B)'/",+$type,+$matches,PREG_PATTERN_ORDER+);
+++++return+$matches[1];


}|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1101720|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>$row = db_fetch_object($result);
 if($row){
 $type = $row-&gt;Type;
 preg_match_all("/'([^']+)'/", $type, $matches,PREG_PATTERN_ORDER );
 return $matches[1];


}
</code></pre>

blocks|key|1101786|text|您可以将字符串作为CSV+(逗号分隔值)字符串进行解析。PHP有一个很棒的内置函数，叫做str_getcsv，它可以将CSV字符串转换成数组。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1101787|//+This+is+an+example+to+test+with
$enum_or_set+=+"'blond','brunette','redhead'";

//+Here+is+the+parser
$options+=+str_getcsv($enum_or_set,+',',+"'");

//+Output+the+value
print_r($options);|code-block|syntax|javascript|1101788|这将为您提供类似于以下内容的内容：|1101789|Array
(
++++[0]+=>+blond
++++[1]+=>+brunette
++++[2]+=>+redhead
)|1101790|此方法还允许在字符串中使用单引号(请注意使用了两个单引号)：|1101791|$enum_or_set+=+"'blond','brunette','red''head'";

Array
(
++++[0]+=>+blond
++++[1]+=>+brunette
++++[2]+=>+red'head
)|1101792|有关str_getcsv函数的更多信息，请查看PHP手册：http://uk.php.net/manual/en/function.str-getcsv.php|offset|length|1101793|entityMap|0|LINK|mutability|MUTABLE|url|http://uk.php.net/manual/en/function.str-getcsv.php^0|0|0|0|0|0|0|T|1F|0|0^^$0|@$1|2|3|4|5|6|7|10|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|11|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|12|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|13|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|14|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|15|8|@]|9|@]|A|$E|F]]|$1|O|3|P|5|6|7|16|8|@]|9|@$Q|17|R|18|1|19]]|A|$]]|$1|S|3|-4|5|6|7|1A|8|@]|9|@]|A|$]]]|T|$U|$5|V|W|X|A|$Y|Z]]]]

You can parse the string as though it was a CSV (Comma Separated Value) string. PHP has a great build-in function called str_getcsv which converts a CSV string to an array.

<pre><code>// This is an example to test with
$enum_or_set = "'blond','brunette','redhead'";

// Here is the parser
$options = str_getcsv($enum_or_set, ',', "'");

// Output the value
print_r($options);
</code></pre>

This should give you something similar to the following:

<pre><code>Array
(
 [0] =&gt; blond
 [1] =&gt; brunette
 [2] =&gt; redhead
)
</code></pre>

This method also allows you to have single quotes in your strings (notice the use of two single quotes):

<pre><code>$enum_or_set = "'blond','brunette','red''head'";

Array
(
 [0] =&gt; blond
 [1] =&gt; brunette
 [2] =&gt; red'head
)
</code></pre>

For more information on the str_getcsv function, check the PHP manual:
<a href="http://uk.php.net/manual/en/function.str-getcsv.php">http://uk.php.net/manual/en/function.str-getcsv.php</a>

blocks|key|1101837|text|我有一个代码点火者的版本给你。它还去掉了值中的引号。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1101838|function+get_enum_values(+$table,+$field+)
{
++++$type+=+$this->db->query(+"SHOW+COLUMNS+FROM+{$table}+WHERE+Field+=+'{$field}'"+)->row(+0+)->Type;
++++preg_match("/%5Eenum$\'(.*)\'$$/",+$type,+$matches);
++++$enum+=+explode("','",+$matches[1]);
++++return+$enum;
}|code-block|syntax|javascript|1101839|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

I have a codeigniter version for you. It also strips the quotes from the values.

<pre><code>function get_enum_values( $table, $field )
{
 $type = $this-&gt;db-&gt;query( "SHOW COLUMNS FROM {$table} WHERE Field = '{$field}'" )-&gt;row( 0 )-&gt;Type;
 preg_match("/^enum$\'(.*)\'$$/", $type, $matches);
 $enum = explode("','", $matches[1]);
 return $enum;
}
</code></pre>

blocks|key|1316811|text|尝尝这个|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1316812|describe+table+columnname|code-block|syntax|javascript|1316813|为您提供该表中该列的所有信息；|1316814|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

try this

<pre><code>describe table columnname
</code></pre>

gives you all the information about that column in that table;

blocks|key|1101894|text|这是一种更新的方法，对我来说很管用：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1101895|function+enum_to_array($table,+$field)+{++++
++++$query+=+"SHOW+FIELDS+FROM+`{$table}`+LIKE+'{$field}'";
++++$result+=+$db->query($sql);
++++$row+=+$result->fetchRow();
++++preg_match('#%5Eenum$(.*?)$$#ism',+$row['Type'],+$matches);
++++$enum+=+str_getcsv($matches[1],+",",+"'");
++++return+$enum;
}|code-block|syntax|javascript|1101896|最终，从"+enum+()“中分离出来的枚举值只是一个CSV字符串，所以可以这样解析它！|1101897|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

A more up to date way of doing it, this worked for me:

<pre><code>function enum_to_array($table, $field) { 
 $query = "SHOW FIELDS FROM `{$table}` LIKE '{$field}'";
 $result = $db-&gt;query($sql);
 $row = $result-&gt;fetchRow();
 preg_match('#^enum$(.*?)$$#ism', $row['Type'], $matches);
 $enum = str_getcsv($matches[1], ",", "'");
 return $enum;
}
</code></pre>

Ultimately, the enum values when separated from "enum()" is just a CSV string, so parse it as such!

blocks|key|1101935|text|这与上面的许多方法类似，但给出了没有循环的结果，并获得了您真正想要的结果:一个用于生成select选项的简单数组。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1101936|额外的好处:它适用于SET和ENUM字段类型。|1101937|$result+=+$db->query("SHOW+COLUMNS+FROM+table+LIKE+'column'");
if+($result)+{
++++$option_array+=+explode("','",preg_replace("/(enum%7Cset)$'(.%2B?)'$/","\\2",+$result[0]->Type));
}|code-block|syntax|javascript|1101938|$option_array:阵列(+=>红色1个=>绿色2个=>蓝色)|1101939|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|N|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|O|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|P|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

This is like a lot of the above, but gives you the result without loops, AND gets you want you really want: a simple array for generating select options.

BONUS: It works for SET as well as ENUM field types.

<pre><code>$result = $db-&gt;query("SHOW COLUMNS FROM table LIKE 'column'");
if ($result) {
 $option_array = explode("','",preg_replace("/(enum|set)$'(.+?)'$/","\\2", $result[0]-&gt;Type));
}
</code></pre>

$option_array:
Array
(
 [0] => red
 [1] => green
 [2] => blue
)

blocks|key|1101953|text|这里是Patrick+Savalle为框架Laravel改编的相同函数|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1101954|function+get_enum_values($table,+$field)
{

+++$test=DB::select(DB::raw("show+columns+from+{$table}+where+field+=+'{$field}'"));

+++preg_match('/%5Eenum$(.*)$$/',+$test[0]->Type,+$matches);
+++foreach(+explode(',',+$matches[1])+as+$value+)
+++{
+++++++$enum[]+=+trim(+$value,+"'"+);+++
+++}

+++return+$enum;

}|code-block|syntax|javascript|1101955|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Here is the same function given by Patrick Savalle adapted for the framework Laravel

<pre><code>function get_enum_values($table, $field)
{

 $test=DB::select(DB::raw("show columns from {$table} where field = '{$field}'"));

 preg_match('/^enum$(.*)$$/', $test[0]-&gt;Type, $matches);
 foreach( explode(',', $matches[1]) as $value )
 {
 $enum[] = trim( $value, "'" ); 
 }

 return $enum;

}
</code></pre>

blocks|key|1316946|text|Codeigniter将版本改编为某些模型的方法：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1316947|public+function+enum_values($table_name,+$field_name)
{
++++$query+=+$this->db->query("SHOW+COLUMNS+FROM+`{$table_name}`+LIKE+'{$field_name}'");

++++if(!$query->num_rows())+return+array();
++++preg_match_all('~\'([%5E\']*)\'~',+$query->row('Type'),+$matches);

++++return+$matches[1];
}|code-block|syntax|javascript|1316948|结果：|1316949|array(2)+{
++++[0]=>+string(13)+"administrator"
++++[1]=>+string(8)+"customer"
}|1316950|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

Codeigniter adapting version as method of some model:

<pre><code>public function enum_values($table_name, $field_name)
{
 $query = $this-&gt;db-&gt;query("SHOW COLUMNS FROM `{$table_name}` LIKE '{$field_name}'");

 if(!$query-&gt;num_rows()) return array();
 preg_match_all('~\'([^\']*)\'~', $query-&gt;row('Type'), $matches);

 return $matches[1];
}
</code></pre>

Result:

<pre><code>array(2) {
 [0]=&gt; string(13) "administrator"
 [1]=&gt; string(8) "customer"
}
</code></pre>

blocks|key|1317012|text|所有人都使用一些奇怪而复杂的正则表达式模式x)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1317013|以下是我在没有preg_match的情况下的解决方案：|1317014|function+getEnumTypes($table,+$field)+{
++++$query+=+$this->db->prepare("SHOW+COLUMNS+FROM+$table+WHERE+Field+=+?");
++++try+{$query->execute(array($field));}+catch+(Exception+$e)+{error_log($e->getMessage());}
++++$types+=+$query->fetchAll(PDO::FETCH_COLUMN%7CPDO::FETCH_UNIQUE,+1)[$field];
++++return+explode("','",+trim($types,+"enum()'"));
}|code-block|syntax|javascript|1317015|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|L|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|M|8|@]|9|@]|A|$G|H]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

All of you use some strange and complex regex patterns x)

Here's my solution without preg_match :

<pre><code>function getEnumTypes($table, $field) {
 $query = $this-&gt;db-&gt;prepare("SHOW COLUMNS FROM $table WHERE Field = ?");
 try {$query-&gt;execute(array($field));} catch (Exception $e) {error_log($e-&gt;getMessage());}
 $types = $query-&gt;fetchAll(PDO::FETCH_COLUMN|PDO::FETCH_UNIQUE, 1)[$field];
 return explode("','", trim($types, "enum()'"));
}
</code></pre>

blocks|key|1317061|text|这对我来说很有效：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1317062|SELECT+REPLACE(SUBSTRING(COLUMN_TYPE,6,(LENGTH(COLUMN_TYPE)-6)),"'","")
FROM+information_schema.COLUMNS
WHERE+TABLE_SCHEMA='__TABLE_SCHEMA__'+
AND+TABLE_NAME='__TABLE_NAME__'
AND+COLUMN_NAME='__COLUMN_NAME__'|code-block|syntax|javascript|1317063|然后|1317064|explode(',',+$data)|1317065|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

this will work for me:

<pre><code>SELECT REPLACE(SUBSTRING(COLUMN_TYPE,6,(LENGTH(COLUMN_TYPE)-6)),"'","")
FROM information_schema.COLUMNS
WHERE TABLE_SCHEMA='__TABLE_SCHEMA__' 
AND TABLE_NAME='__TABLE_NAME__'
AND COLUMN_NAME='__COLUMN_NAME__'
</code></pre>

and then 

<pre><code>explode(',', $data)
</code></pre>

blocks|key|1102132|text|您可以使用以下语法在MySQL查询中获取枚举可能值：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1102133|$syntax+=+"SELECT+COLUMN_TYPY+FROM+information_schema.`COLUMNS`+
WHERE+TABLE_NAME+=+'{$THE_TABLE_NAME}'+
AND+COLUMN_NAME+=+'{$THE_COLUMN_OF_TABLE}'";|code-block|syntax|javascript|1102134|然后你得到值，例如:+enum('Male'，'Female')|1102135|下面是sytax+php示例：|1102136|<?php
function+($table,$colm){

//+mysql+query.
$syntax+=+mysql_query("SELECT+COLUMN_TYPY+FROM+information_schema.`COLUMNS`+
WHERE+TABLE_NAME+=+'$table'+AND+COLUMN_NAME+='$colm'");

if+(!mysql_error()){
+//Get+a+array+possible+values+from+table+and+colm.
+$array_string+=+mysql_fetch_array($syntax);

++++//Remove+part+string
++++$string+=+str_replace("'",+"",+$array_string['COLUMN_TYPE']);
++++$string+=+str_replace(')',+"",+$string);
++++$string+=+explode(",",substr(5,$string));
}else{
++++$string+=+"error+mysql+:".mysql_error();
}
//+Values+is+(Examples)+Male,Female,Other
return+$string;
}
?>|1102137|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|R|8|@]|9|@]|A|$]]|$1|K|3|L|5|D|7|S|8|@]|9|@]|A|$E|F]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

You can use this syntax for get enum possible values in MySQL QUERY :

<pre><code>$syntax = "SELECT COLUMN_TYPY FROM information_schema.`COLUMNS` 
WHERE TABLE_NAME = '{$THE_TABLE_NAME}' 
AND COLUMN_NAME = '{$THE_COLUMN_OF_TABLE}'";
</code></pre>

and you get value, example : enum('Male','Female')

this is example sytax php:

<pre><code>&lt;?php
function ($table,$colm){

// mysql query.
$syntax = mysql_query("SELECT COLUMN_TYPY FROM information_schema.`COLUMNS` 
WHERE TABLE_NAME = '$table' AND COLUMN_NAME ='$colm'");

if (!mysql_error()){
 //Get a array possible values from table and colm.
 $array_string = mysql_fetch_array($syntax);

 //Remove part string
 $string = str_replace("'", "", $array_string['COLUMN_TYPE']);
 $string = str_replace(')', "", $string);
 $string = explode(",",substr(5,$string));
}else{
 $string = "error mysql :".mysql_error();
}
// Values is (Examples) Male,Female,Other
return $string;
}
?&gt;
</code></pre>

blocks|key|1317158|text|这是给mysqli的|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1317159|function+get_enum_values($mysqli,+$table,+$field+)
{
++++$type+=+$mysqli->query("SHOW+COLUMNS+FROM+{$table}+WHERE+Field+=+'{$field}'")->fetch_array(MYSQLI_ASSOC)['Type'];
++++preg_match("/%5Eenum$\'(.*)\'$$/",+$type,+$matches);
++++$enum+=+explode("','",+$matches[1]);
++++return+$enum;
}
$deltypevals+=+get_enum_values($mysqli,+'orders',+'deltype');
var_dump+($deltypevals);|code-block|syntax|javascript|1317160|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

here is for mysqli 

<pre><code>function get_enum_values($mysqli, $table, $field )
{
 $type = $mysqli-&gt;query("SHOW COLUMNS FROM {$table} WHERE Field = '{$field}'")-&gt;fetch_array(MYSQLI_ASSOC)['Type'];
 preg_match("/^enum$\'(.*)\'$$/", $type, $matches);
 $enum = explode("','", $matches[1]);
 return $enum;
}
$deltypevals = get_enum_values($mysqli, 'orders', 'deltype');
var_dump ($deltypevals);
</code></pre>

blocks|key|1317177|text|对于Laravel来说，这是可行的：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1317178|$result+=+DB::select("SHOW+COLUMNS+FROM+`table_name`+LIKE+'status';");
$regex+=+"/'(.*?)'/";
preg_match_all(+$regex+,+$result[0]->Type,+$enum_array+);
$enum_fields+=+$enum_array[1];
echo+"<pre>";
print_r($enum_fields);|code-block|syntax|javascript|1317179|输出：|1317180|Array
(
[0]+=>+Requested
[1]+=>+Call+Back
[2]+=>+Busy
[3]+=>+Not+Reachable
[4]+=>+Not+Responding
)|1317181|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

For Laravel this worked:

<pre><code>$result = DB::select("SHOW COLUMNS FROM `table_name` LIKE 'status';");
$regex = "/'(.*?)'/";
preg_match_all( $regex , $result[0]-&gt;Type, $enum_array );
$enum_fields = $enum_array[1];
echo "&lt;pre&gt;";
print_r($enum_fields);
</code></pre>

Output:

<pre><code>Array
(
[0] =&gt; Requested
[1] =&gt; Call Back
[2] =&gt; Busy
[3] =&gt; Not Reachable
[4] =&gt; Not Responding
)
</code></pre>

blocks|key|1102301|text|我以这种方式获取枚举值：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1102302|SELECT+COLUMN_TYPE+
FROM+information_schema.`COLUMNS`+
WHERE+TABLE_NAME+=+'tableName'+
+++++AND+COLUMN_NAME+=+'columnName';|code-block|syntax|javascript|1102303|运行这个sql，我有get+:+enum('BDBL'，'AB+Bank')|1102304|然后我已经使用以下代码过滤了值：|1102305|preg_match("/%5Eenum$\'(.*)\'$$/",+$type,+$matches);
$enum+=+explode("','",+$matches[1]);
var_dump($enum)+;|1102306|输出：|1102307|array(2)+{
++[0]=>
++string(4)+"BDBL"
++[1]=>
++string(7)+"AB+Bank"
}|1102308|entityMap^0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|V|8|@]|9|@]|A|$]]|$1|K|3|L|5|D|7|W|8|@]|9|@]|A|$E|F]]|$1|M|3|N|5|6|7|X|8|@]|9|@]|A|$]]|$1|O|3|P|5|D|7|Y|8|@]|9|@]|A|$E|F]]|$1|Q|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|R|$]]

I get enum values in this way:
<pre><code>SELECT COLUMN_TYPE 
FROM information_schema.`COLUMNS` 
WHERE TABLE_NAME = 'tableName' 
 AND COLUMN_NAME = 'columnName';
</code></pre>
Running this sql I have get : enum('BDBL','AB Bank')
then I have filtered just value using following code :
<pre><code>preg_match(&quot;/^enum$\'(.*)\'$$/&quot;, $type, $matches);
$enum = explode(&quot;','&quot;, $matches[1]);
var_dump($enum) ;
</code></pre>
Out put :
<pre><code>array(2) {
 [0]=&gt;
 string(4) &quot;BDBL&quot;
 [1]=&gt;
 string(7) &quot;AB Bank&quot;
}
</code></pre>

blocks|key|1317320|text|这个线程中所有其他答案的问题是，它们都不能正确解析枚举中字符串的所有特殊情况。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1317321|最大的特殊情况是单引号，因为它们被编码成两个单引号在一起！因此，例如，值为'a'的枚举被编码为enum('''a''')。很可怕，对吧？|offset|length|style|CODE|1317322|那么，解决方案就是使用MySQL为您解析数据！|1317323|因为每个人都在这个线程中使用PHP，所以这就是我要使用的。以下是完整的代码。我稍后会解释的。参数$FullEnumString将保存整个枚举字符串，该字符串是从您想要使用的所有其他答案的方法中提取的。RunQuery()和FetchRow()+(非关联)是您喜欢的数据库访问方法的替身。|1317324|function+GetDataFromEnum($FullEnumString)
{
++++if(!preg_match('/%5Eenum$(.*)$$/iD',+$FullEnumString,+$Matches))
++++++++return+null;
++++return+FetchRow(RunQuery('SELECT+'.$Matches[1]));
}|code-block|syntax|javascript|1317325|preg_match('/%5Eenum$(.*)$$/iD',+$FullEnumString,+$Matches)确认枚举值与我们期望的值匹配，也就是"enum(".$STUFF.")"+(前后没有任何内容)。如果preg_match失败，则返回NULL。|1317326|此preg_match还在$Matches[1]中存储以奇怪的SQL语法转义的字符串列表。接下来，我们希望能够从中获得真实的数据。所以您只需运行"SELECT+".$Matches[1]，您就拥有了第一条记录中的字符串的完整列表！|1317327|因此，只需使用FetchRow(RunQuery(...))取出该记录，就完成了。|1317328|如果您想在SQL中完成整个操作，可以使用以下命令|1317329|SET+@TableName='your_table_name',+@ColName='your_col_name';
SET+@Q=(SELECT+CONCAT('SELECT+',+(SELECT+SUBSTR(COLUMN_TYPE,+6,+LENGTH(COLUMN_TYPE)-6)+FROM+information_schema.COLUMNS+WHERE+TABLE_NAME=@TableName+AND+COLUMN_NAME=@ColName)));
PREPARE+stmt+FROM+@Q;
EXECUTE+stmt;|1317330|另外，为了阻止任何人对此发表评论，不，我不相信这种方法会导致SQL注入。|1317331|entityMap^0|0|11|3|1B|D|0|0|1C|F|2S|A|33|A|0|0|0|1N|25|I|3H|4|0|1|A|D|B|20|L|0|7|N|0|0|0|0^^$0|@$1|2|3|4|5|6|7|14|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|15|8|@$D|16|E|17|F|G]|$D|18|E|19|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|1A|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|1B|8|@$D|1C|E|1D|F|G]|$D|1E|E|1F|F|G]|$D|1G|E|1H|F|G]]|9|@]|A|$]]|$1|L|3|M|5|N|7|1I|8|@]|9|@]|A|$O|P]]|$1|Q|3|R|5|6|7|1J|8|@$D|1K|E|1L|F|G]|$D|1M|E|1N|F|G]|$D|1O|E|1P|F|G]]|9|@]|A|$]]|$1|S|3|T|5|6|7|1Q|8|@$D|1R|E|1S|F|G]|$D|1T|E|1U|F|G]|$D|1V|E|1W|F|G]]|9|@]|A|$]]|$1|U|3|V|5|6|7|1X|8|@$D|1Y|E|1Z|F|G]]|9|@]|A|$]]|$1|W|3|X|5|6|7|20|8|@]|9|@]|A|$]]|$1|Y|3|Z|5|N|7|21|8|@]|9|@]|A|$O|P]]|$1|10|3|11|5|6|7|22|8|@]|9|@]|A|$]]|$1|12|3|-4|5|6|7|23|8|@]|9|@]|A|$]]]|13|$]]

The problem with every other answer in this thread is that none of them properly parse all special cases of the strings within the enum.

The biggest special case character that was throwing me for a loop was single quotes, as they are encoded themselves as 2 single quotes together! So, for example, an enum with the value <code>'a'</code> is encoded as <code>enum('''a''')</code>. Horrible, right?

Well, the solution is to use MySQL to parse the data for you!

Since everyone else is using PHP in this thread, that is what I will use. Following is the full code. I will explain it after. The parameter <code>$FullEnumString</code> will hold the entire enum string, extracted from whatever method you want to use from all the other answers. <code>RunQuery()</code> and <code>FetchRow()</code> (non associative) are stand ins for your favorite DB access methods.

<pre><code>function GetDataFromEnum($FullEnumString)
{
 if(!preg_match('/^enum$(.*)$$/iD', $FullEnumString, $Matches))
 return null;
 return FetchRow(RunQuery('SELECT '.$Matches[1]));
}
</code></pre>

<code>preg_match('/^enum$(.*)$$/iD', $FullEnumString, $Matches)</code> confirms that the enum value matches what we expect, which is to say, <code>"enum(".$STUFF.")"</code> (with nothing before or after). If the preg_match fails, <code>NULL</code> is returned.

This <code>preg_match</code> also stores the list of strings, escaped in weird SQL syntax, in <code>$Matches[1]</code>. So next, we want to be able to get the real data out of that. So you just run <code>"SELECT ".$Matches[1]</code>, and you have a full list of the strings in your first record!

So just pull out that record with a <code>FetchRow(RunQuery(...))</code> and you’re done.

If you wanted to do this entire thing in SQL, you could use the following

<pre><code>SET @TableName='your_table_name', @ColName='your_col_name';
SET @Q=(SELECT CONCAT('SELECT ', (SELECT SUBSTR(COLUMN_TYPE, 6, LENGTH(COLUMN_TYPE)-6) FROM information_schema.COLUMNS WHERE TABLE_NAME=@TableName AND COLUMN_NAME=@ColName)));
PREPARE stmt FROM @Q;
EXECUTE stmt;
</code></pre>

P.S. To preempt anyone from saying something about it, no, I do not believe this method can lead to SQL injection.

blocks|key|1317399|text|为了获取可能值的列表已经有了很好的文档，但是expanding+on+another+answer+that+returned+the+values+in+parenthesis，我想把它们去掉，留下一个逗号分隔的列表，这样我就可以在需要获取数组的时候使用分解类型的函数。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1317400|SELECT
++++SUBSTRING(COLUMN_TYPE,+6,+LENGTH(COLUMN_TYPE)+-+6)+AS+val
FROM
++++information_schema.COLUMNS
WHERE
++++TABLE_NAME+=+'articles'
AND
++++COLUMN_NAME+=+'status'|code-block|syntax|javascript|1317401|SUBSTRING现在从第6个字符开始，并使用比总数短6个字符的长度，去掉了尾部的括号。|style|CODE|1317402|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/a/2350145/750593^0|M|1V|0|0|0|0|9|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@$A|V|B|W|1|X]]|C|$]]|$1|D|3|E|5|F|7|Y|8|@]|9|@]|C|$G|H]]|$1|I|3|J|5|6|7|Z|8|@$A|10|B|11|K|L]]|9|@]|C|$]]|$1|M|3|-4|5|6|7|12|8|@]|9|@]|C|$]]]|N|$O|$5|P|Q|R|C|$S|T]]]]

To fetch the list of possible values has been well documented, but <a href="https://stackoverflow.com/a/2350145/750593">expanding on another answer that returned the values in parenthesis</a>, I wanted to strip them out leaving me with a comma separated list that would then allow me to use an explode type function whenever I needed to get an array.

<pre><code>SELECT
 SUBSTRING(COLUMN_TYPE, 6, LENGTH(COLUMN_TYPE) - 6) AS val
FROM
 information_schema.COLUMNS
WHERE
 TABLE_NAME = 'articles'
AND
 COLUMN_NAME = 'status'
</code></pre>

The <code>SUBSTRING</code> now starts at the 6th character and uses a length which is 6 characters shorter than the total, removing the trailing parenthesis.

blocks|key|1317446|text|对于PHP+5.6%2B|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1317447|$mysqli+=+new+mysqli("example.com","username","password","database");
$result+=+$mysqli->query("SELECT+COLUMN_TYPE+FROM+INFORMATION_SCHEMA.COLUMNS+WHERE+TABLE_NAME='table_name'+AND+COLUMN_NAME='column_name'");
$row+=+$result->fetch_assoc();
var_dump($row);|code-block|syntax|javascript|1317448|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

For PHP 5.6+ 

<pre><code>$mysqli = new mysqli("example.com","username","password","database");
$result = $mysqli-&gt;query("SELECT COLUMN_TYPE FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='table_name' AND COLUMN_NAME='column_name'");
$row = $result-&gt;fetch_assoc();
var_dump($row);
</code></pre>

blocks|key|1102510|text|DELIMITER+//

++++DROP+FUNCTION+IF+EXISTS+ENUM_VALUES;

++++CREATE+FUNCTION+ENUM_VALUES(

++++++++_table_name+VARCHAR(64),+
++++++++_col_name+VARCHAR(64)

++++)+RETURNS+JSON

++++++++BEGIN

++++++++++++RETURN+(
++++++++++++++++SELECT+CAST(CONCAT('[',+REPLACE(SUBSTRING(COLUMN_TYPE,+6,+LENGTH(COLUMN_TYPE)+-+6),+"'",+'"'),+']')+AS+JSON)
++++++++++++++++++FROM+information_schema.COLUMNS
+++++++++++++++++WHERE+TABLE_SCHEMA+=+'db_name'
+++++++++++++++++++AND+TABLE_NAME+++=+_table_name
+++++++++++++++++++AND+COLUMN_NAME++=+_col_name
+++++++++++++++++++AND+DATA_TYPE++++=+'enum'
++++++++++++);

++++++++END+//

DELIMITER+;|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1102511|示例：|unstyled|1102512|SELECT+ENUM_VALUES('table_name',+'col_name');|1102513|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|L|8|@]|9|@]|A|$]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$B|C]]|$1|I|3|-4|5|F|7|N|8|@]|9|@]|A|$]]]|J|$]]

<pre><code>DELIMITER //

 DROP FUNCTION IF EXISTS ENUM_VALUES;

 CREATE FUNCTION ENUM_VALUES(

 _table_name VARCHAR(64), 
 _col_name VARCHAR(64)

 ) RETURNS JSON

 BEGIN

 RETURN (
 SELECT CAST(CONCAT('[', REPLACE(SUBSTRING(COLUMN_TYPE, 6, LENGTH(COLUMN_TYPE) - 6), "'", '"'), ']') AS JSON)
 FROM information_schema.COLUMNS
 WHERE TABLE_SCHEMA = 'db_name'
 AND TABLE_NAME = _table_name
 AND COLUMN_NAME = _col_name
 AND DATA_TYPE = 'enum'
 );

 END //

DELIMITER ;
</code></pre>

Example:

<pre><code>SELECT ENUM_VALUES('table_name', 'col_name');
</code></pre>

blocks|key|1102557|text|很奇怪，你们没有人想到，如果你使用枚举字段，这意味着要赋值的值是“先验的”。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1102558|因此，如果这些值是“先验的”，那么管理它们的最好方法就是通过一个非常简单的Enum类。|1102559|亲吻规则并保存一次数据库调用。|1102560|<?php
class+Genre+extends+\SplEnum+{
+const+male+=+"Male";
+const+female+=+"Female";
}|code-block|syntax|javascript|1102561|http://it2.php.net/manual/en/class.splenum.php|offset|length|1102562|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|0|0|0|1A|0|0^^$0|@$1|2|3|4|5|6|7|V|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|W|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|X|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|Y|8|@]|9|@]|A|$I|J]]|$1|K|3|L|5|6|7|Z|8|@]|9|@$M|10|N|11|1|12]]|A|$]]|$1|O|3|-4|5|6|7|13|8|@]|9|@]|A|$]]]|P|$Q|$5|R|S|T|A|$U|L]]]]

It is extraordinary how none of you has thought that if you are using an enum field it means that the values to be assigned are known "a priori".

Therefore if the values are known "a priori" the best ways to manage them is through a very simple Enum class.

Kiss rule and save one database call.

<pre><code>&lt;?php
class Genre extends \SplEnum {
 const male = "Male";
 const female = "Female";
}
</code></pre>

<a href="http://it2.php.net/manual/en/class.splenum.php" rel="nofollow noreferrer">http://it2.php.net/manual/en/class.splenum.php</a>

blocks|key|1317568|text|这是一个自定义WordPress表的解决方案。这将适用于不带逗号(,)的ENUM值|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1317569|function+get_enum_values($wpdb,+$table,+$field)+{

++++$values+=+array();
++++$table+=+"{$wpdb->prefix}{$table}";
++++$query+=+"SHOW+COLUMNS+FROM+{$table}+WHERE+Field+=+'{$field}'";
++++$results+=+$wpdb->get_results($query,+ARRAY_A);

++++if+(is_array($results)+&&+count($results)+>+0)+{

++++++++preg_match("/%5Eenum$\'(.*)\'$$/",+$results[0]['Type'],+$matches);

++++++++if+(is_array($matches)+&&+isset($matches[1]))+{

++++++++++++$values+=+explode("','",+$matches[1]);

++++++++}

++++}

++++return+$values;

}|code-block|syntax|javascript|1317570|entityMap^0|W|3|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|P|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|Q|8|@]|D|@]|E|$]]]|L|$]]

Here is a solution for a custom WordPress table. This will work for ENUM values without a comma <code>(,)</code> in them
<pre><code>function get_enum_values($wpdb, $table, $field) {

 $values = array();
 $table = &quot;{$wpdb-&gt;prefix}{$table}&quot;;
 $query = &quot;SHOW COLUMNS FROM {$table} WHERE Field = '{$field}'&quot;;
 $results = $wpdb-&gt;get_results($query, ARRAY_A);

 if (is_array($results) &amp;&amp; count($results) &gt; 0) {

 preg_match(&quot;/^enum$\'(.*)\'$$/&quot;, $results[0]['Type'], $matches);

 if (is_array($matches) &amp;&amp; isset($matches[1])) {

 $values = explode(&quot;','&quot;, $matches[1]);

 }

 }

 return $values;

}
</code></pre>

blocks|key|1102697|text|添加到cchana的答案中。方法"length-6“在枚举中的非拉丁值上失败。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1102698|例如(值以西里尔文表示，表为UTF8+-+utf8_general_ci。在示例中，为了简单起见，我使用了变量:+selecting+from+schema给出了相同的结果)：|1102699|set+@a:="enum('в+работе','на+списание','списано')";
select+substring(@a,6,length(@a)-6);
%2B-------------------------------------------------------------%2B
%7C+substring(@a,6,length(@a)-6)++++++++++++++++++++++++++++++++%7C
%2B-------------------------------------------------------------%2B
%7C+'в+работе','на+списание','списано')+++++++++++++++++++++++++%7C
%2B-------------------------------------------------------------%2B|code-block|syntax|javascript|1102700|注意到右括号了吗？|1102701|select+right(@a,1);
%2B-------------%2B
%7C+right(@a,1)+%7C
%2B-------------%2B
%7C+)+++++++++++%7C
%2B-------------%2B|1102702|好吧，让我们再试着去掉一个字符：|1102703|select+substring(@a,6,length(@a)-7);
%2B-------------------------------------------------------------%2B
%7C+substring(@a,6,length(@a)-7)++++++++++++++++++++++++++++++++%7C
%2B-------------------------------------------------------------%2B
%7C+'в+работе','на+списание','списано')+++++++++++++++++++++++++%7C
%2B-------------------------------------------------------------%2B|1102704|不走运！括号保持在适当的位置。|1102705|检查(mid()函数的工作方式类似于substring()，两者显示相同的结果)：|offset|length|style|CODE|1102706|select+mid(@a,6,length(@a)/2);
%2B---------------------------------------------------------%2B
%7C+mid(@a,6,length(@a)/2)++++++++++++++++++++++++++++++++++%7C
%2B---------------------------------------------------------%2B
%7C+'в+работе','на+списание','списан++++++++++++++++++++++++%7C
%2B---------------------------------------------------------%2B|1102707|看:字符串只丢失了最右边的三个字符。但我们是否应该用拉丁语取代西里尔语，所有这些都能完美地工作：|1102708|set+@b:="enum('in+use','for+removal','trashed')";
select+(substring(@b,6,length(@b)-6));
%2B----------------------------------%2B
%7C+(substring(@b,6,length(@b)-6))+++%7C
%2B----------------------------------%2B
%7C+'in+use','for+removal','trashed'+%7C
%2B----------------------------------%2B|1102709|JFYI|1102710|编辑20210221:非拉丁字符的解决方案是CHAR_LENGTH()而不是"simple“LENGTH()|1102711|entityMap^0|0|0|0|0|0|0|0|0|3|5|I|B|0|0|0|0|0|M|D|1A|8|0^^$0|@$1|2|3|4|5|6|7|1A|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1B|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|1C|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|1D|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|1E|8|@]|9|@]|A|$G|H]]|$1|M|3|N|5|6|7|1F|8|@]|9|@]|A|$]]|$1|O|3|P|5|F|7|1G|8|@]|9|@]|A|$G|H]]|$1|Q|3|R|5|6|7|1H|8|@]|9|@]|A|$]]|$1|S|3|T|5|6|7|1I|8|@$U|1J|V|1K|W|X]|$U|1L|V|1M|W|X]]|9|@]|A|$]]|$1|Y|3|Z|5|F|7|1N|8|@]|9|@]|A|$G|H]]|$1|10|3|11|5|6|7|1O|8|@]|9|@]|A|$]]|$1|12|3|13|5|F|7|1P|8|@]|9|@]|A|$G|H]]|$1|14|3|15|5|6|7|1Q|8|@]|9|@]|A|$]]|$1|16|3|17|5|6|7|1R|8|@$U|1S|V|1T|W|X]|$U|1U|V|1V|W|X]]|9|@]|A|$]]|$1|18|3|-4|5|6|7|1W|8|@]|9|@]|A|$]]]|19|$]]

Adding to cchana's answer. The method &quot;length-6&quot; fails on non-latin values in enum.
For example (the values are in Cyrillic, table is UTF8 - utf8_general_ci. In the examples I use the variable for simplicity: selecting from schema gives the same):
<pre><code>set @a:=&quot;enum('в работе','на списание','списано')&quot;;
select substring(@a,6,length(@a)-6);
+-------------------------------------------------------------+
| substring(@a,6,length(@a)-6) |
+-------------------------------------------------------------+
| 'в работе','на списание','списано') |
+-------------------------------------------------------------+
</code></pre>
Note the closing parenthesis?
<pre><code>select right(@a,1);
+-------------+
| right(@a,1) |
+-------------+
| ) |
+-------------+
</code></pre>
Well, let's try remove one more character:
<pre><code>select substring(@a,6,length(@a)-7);
+-------------------------------------------------------------+
| substring(@a,6,length(@a)-7) |
+-------------------------------------------------------------+
| 'в работе','на списание','списано') |
+-------------------------------------------------------------+
</code></pre>
No luck! The parenthesis stays in place.
Checking (<code>mid()</code> function works in way similar to <code>substring()</code>, and both shows the same results):
<pre><code>select mid(@a,6,length(@a)/2);
+---------------------------------------------------------+
| mid(@a,6,length(@a)/2) |
+---------------------------------------------------------+
| 'в работе','на списание','списан |
+---------------------------------------------------------+
</code></pre>
See: the string lost only three rightmost characters. But should we replace Cyrillic with Latin, and all works just perfectly:
<pre><code>set @b:=&quot;enum('in use','for removal','trashed')&quot;;
select (substring(@b,6,length(@b)-6));
+----------------------------------+
| (substring(@b,6,length(@b)-6)) |
+----------------------------------+
| 'in use','for removal','trashed' |
+----------------------------------+
</code></pre>
JFYI
Edit 20210221: the solution for non-Latin characters is <code>CHAR_LENGTH()</code> instead of &quot;simple&quot; <code>LENGTH()</code>

blocks|key|1102771|text|这将使用PDO工作：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1102772|$stmt+=+$mysql->prepare("SHOW+COLUMNS+FROM+table+LIKE+'column'");
$stmt->execute();
$enumvalues+=+$stmt->fetch(PDO::FETCH_ASSOC)['Type'];
$enumvalues+=+explode(',',+str_replace('\'',+'',+substr($enumvalues,+5,+strlen($enumvalues)+-+6)));|code-block|syntax|javascript|1102773|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

This will work using PDO:
<pre><code>$stmt = $mysql-&gt;prepare(&quot;SHOW COLUMNS FROM table LIKE 'column'&quot;);
$stmt-&gt;execute();
$enumvalues = $stmt-&gt;fetch(PDO::FETCH_ASSOC)['Type'];
$enumvalues = explode(',', str_replace('\'', '', substr($enumvalues, 5, strlen($enumvalues) - 6)));
</code></pre>

I want to populate my dropdowns with enum possible values from a DB automatically. Is this possible in MySQL?

How can I get enum possible values in a MySQL database?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

我想用数据库中的枚举可能值自动填充我的下拉列表。这在MySQL中是可能的吗？

问如何在MySQL数据库中获取枚举可能值？
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在MySQL数据库中获取枚举可能值？EN