1DATE : YYYY-MM-DD format
2DATETIME : YYYY-MM-DD HH:MM:SS format
3TIMESTAMP : X s from 1970 format
4TIME : HH:MM:SS format
1
2
3
4
5 CREATE TABLE people (
6 id INT AUTO_INCREMENT PRIMARY KEY,
7 first_name VARCHAR(50) NOT NULL,
8 last_name VARCHAR(50) NOT NULL,
9 birth_date DATE NOT NULL
10);