All pastes #806237 Raw Edit

Untitled

public text v1 · immutable
·published 2007-12-05 01:32 UTC
rendered paste body
mysql> create table test(t enum('foo','bar'));
Query OK, 0 rows affected (0.03 sec)

mysql> describe test;
+-------+-------------------+------+-----+---------+-------+
| Field | Type              | Null | Key | Default | Extra |
+-------+-------------------+------+-----+---------+-------+
| t     | enum('foo','bar') | YES  |     | NULL    |       |
+-------+-------------------+------+-----+---------+-------+
1 row in set (0.00 sec)

mysql> INSERT INTO test(t) VALUES('gronk');
Query OK, 1 row affected, 1 warning (0.00 sec)

mysql> select * from test;
+------+
| t    |
+------+
|      |
+------+
1 row in set (0.00 sec)