· 9 years ago · Oct 20, 2016, 02:52 PM
1CREATE DATABASE exams;
2
3CREATE TABLE IF NOT EXISTS students(
4student_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
5first_name VARCHAR(20) NOT NULL,
6middle_name VARCHAR(20),
7last_name VARCHAR(40) NOT NULL,
8email VARCHAR(60) NOT NULL,
9password CHAR(40) NOT NULL,
10reg_date DATETIME NOT NULL,
11PRIMARY KEY (student_id),
12UNIQUE (email)
13);