YEAR: Year 1900-2155 (1 byte) : Year « Data Type « SQL / MySQL

1. SQL / MySQL
2. Data Type
3. Year

YEAR: Year 1900-2155 (1 byte)

 
mysql>
mysql> CREATE TABLE employee(
    ->     id INT,
    ->     startDate YEAR
    -> );
Query OK, 0 rows affected (0.00 sec)

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

   
  

Related examples in the same category