mysql> mysql> mysql> CREATE TABLE Test( -> XY ENUM('Y','N') DEFAULT 'N', -> Size ENUM('S','M','L','XL','XXL'), -> Color ENUM('Black','Red','White') -> ); Query OK, 0 rows affected (0.03 sec)
mysql> mysql> Insert into Test (XY, Size, Color) values ('Y','S','Black'); Query OK, 1 row affected (0.01 sec)
mysql> mysql> select * from Test; +------+------+-------+ | XY | Size | Color | +------+------+-------+ | Y | S | Black | +------+------+-------+ 1 row in set (0.00 sec)
mysql> mysql> select * from Test where size = 0; Empty set (0.02 sec)
mysql> mysql> drop table Test; Query OK, 0 rows affected (0.00 sec)
mysql>
|