mysql> create table enum_test (e enum('a','b','c'));
Query OK, 0 rows affected (0.49 sec)
mysql> insert into enum_test (e) values('a'),('b'),('c');
Query OK, 3 rows affected (0.03 sec)
Records: 3 Duplicates: 0 Warnings: 0
mysql> select * from enum_test;
+------+
| e |
+------+
| a |
| b |
| c |
+------+
3 rows in set (0.00 sec)
mysql> select e from enum_test;
+------+
| e |
+------+
| a |
| b |
| c |
+------+
3 rows in set (0.00 sec)
mysql> select e+1 from enum_test;
+------+
| e+1 |
+------+
| 2 |
| 3 |
| 4 |
+------+
3 rows in set (0.00 sec)
mysql>
mysql enum使用
最新推荐文章于 2022-07-12 13:06:43 发布