在 MySQL 中返回枚举值的最佳方法是什么?
我需要选择一列的枚举值.通过搜索，我发现了两种方法:
I need to select the enum values of a column. From searching I've found two ways:
SELECT column_type FROM information_schema.columns
WHERE table_name = 'MyTable' AND column_name = 'MyColumn';
另一个:
SHOW COLUMNS FROM `mytable` WHERE field = 'type';
虽然第一个查询会给我这个信息:
Although the first query will give me this info:
enum('value1','value2','value3')
第二个查询为我提供了相同的信息，并且还提供了额外的列.我宁愿只获取那些没有 enum() 和逗号的值，是否可能，或者我是否需要解析这些值?并不是说检查是否有更简单的方法很难.
The second query gives me the same and with additional columns as well. I would prefer to just get those values without the enum() and commas, is it possible, or do I need to parse the values out? Not that it's hard just checking if there is an easier way.
假设没有更简单的方法，上面两个查询哪个更好用?我注意到第二个查询在我运行时没有显示查询时间，我几乎认为它根本不需要任何时间.但是如果我打开分析器，我可以看到它确实需要时间，但它似乎快了一点.那么第二个查询会更有效吗?
Assuming there is no easier way, which of the two queries above is better to use? I noticed that the second query doesn't show the query time when I ran it, I almost thought it didn't require any time at all. But if I turn on the profiler I can see that it does take time, but it seem a bit faster. So would the second query be more efficient?
推荐答案
我猜你不能选择这些值，我最终用这个解析了这些值:
I guess you can't select those values out, I ended up parsing the values out with this:
$result = str_replace(array("enum('", "')", "''"), array('', '', "'"), $result);
$arr = explode("','", $result);
return $arr;
相关文章