创建表时,为您想要ENUM值的列设置ENUM类型。让我们首先创建一个表-mysql> create table DemoTable2019
-> (
-> StudentMarks int,
-> StudentStatus ENUM('First','Second','Fail')
-> );
使用插入命令在表中插入一些记录-mysql> insert into DemoTable2019 values(96,'First');
mysql> insert into DemoTable2019 values(28,'Fail');
mysql> insert into DemoTable2019 values(45,'Second');
使用select语句显示表中的所有记录-mysql> select *from DemoTable2019;
这将产生以下输出-+--------------+---------------+
| StudentMarks | StudentStatus |
+--------------+---------------+
| 96 | First |
| 28 | Fail |
| 45 | Second |
+--------------+---------------+
3 rows in set (0.00 sec)
以下是从具有ENUM列值的表中获取记录的查询-mysql> select *from DemoTable2019
-> where StudentMarks=28
-> order by StudentStatus limit 1;
这将产生以下输出-+--------------+---------------+
| StudentMarks | StudentStatus |
+--------------+---------------+
| 28 | Fail |
+--------------+---------------+
1 row in set (0.00 sec)