php - 如何在 PHP 中获取枚举的默认值？

Question

如何在 PHP/MySQL 中获取枚举的默认值？我希望将其用作单选按钮/下拉菜单。

Answer 1

mysql> create table choices ( choice enum('a','b') not null default 'b');Query OK, 0 rows affected (0.00 sec)mysql> desc choices;+--------+---------------+------+-----+---------+-------+| Field  | Type          | Null | Key | Default | Extra |+--------+---------------+------+-----+---------+-------+| choice | enum('a','b') | NO   |     | b       |       |+--------+---------------+------+-----+---------+-------+mysql> show columns from choices like 'choice';+--------+---------------+------+-----+---------+-------+| Field  | Type          | Null | Key | Default | Extra |+--------+---------------+------+-----+---------+-------+| choice | enum('a','b') | NO   |     | b       |       |+--------+---------------+------+-----+---------+-------+

任一查询都可以在 Default 字段上产生结果