ENUM with default value : ENUM « Data Types « MySQL Tutorial

1. MySQL Tutorial
2. Data Types
3. ENUM

mysql>
mysql> CREATE TABLE Employee (
    ->     ID INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
    ->     First_Name VARCHAR(20) NOT NULL,
    ->     Last_Name VARCHAR(30) NOT NULL,
    ->     Age INT,
    ->     Gender ENUM('M', 'F') DEFAULT 'F',
    ->     Favorite_Activity ENUM('Programming', 'Eating','Biking', 'Running', 'None') DEFAULT 'None'
    -> );
Query OK, 0 rows affected (0.05 sec)

mysql>
mysql> desc Employee;
+-------------------+--------------------------------------------------------+------+-----+---------+----------------+
| Field             | Type                                                   | Null | Key | Default | Extra          |
+-------------------+--------------------------------------------------------+------+-----+---------+----------------+
| ID                | int(11)                                                | NO   | PRI | NULL    | auto_increment |
| First_Name        | varchar(20)                                            | NO   |     |         |                |
| Last_Name         | varchar(30)                                            | NO   |     |         |                |
| Age               | int(11)                                                | YES  |     | NULL    |                |
| Gender            | enum('M','F')                                          | YES  |     | F       |                |
| Favorite_Activity | enum('Programming','Eating','Biking','Running','None') | YES  |     | None    |                |
+-------------------+--------------------------------------------------------+------+-----+---------+----------------+
6 rows in set (0.01 sec)

mysql>
mysql> drop table Employee;
Query OK, 0 rows affected (0.00 sec)

mysql>