创建表时,为您想要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)