mysql - 如何获取 SET 字段的可用值？

Question

有什么方法可以获取表中 SET 字段的可用值吗？

谢谢。

Answer 1

您可以使用 DESCRIBE myTableName mySetColumn 或 SHOW COLUMNS FROM myTableName LIKE mySetColumn 检索 SET 字段的可能值:

  mysql> DESCRIBE myTableName mySetColumn;
  +-------+-------------------------------------------+------+-----+---------+-------+
  | Field | Type                                      | Null | Key | Default | Extra |
  +-------+-------------------------------------------+------+-----+---------+-------+
  | myset | set('Travel','Sports','Dancing','Dining') | YES  |     | NULL    |       |
  +-------+-------------------------------------------+------+-----+---------+-------+

资料性文章here , 说明书 here .