· 9 years ago · Nov 24, 2016, 10:26 AM
1CREATE TABLE IF NOT EXISTS subjects(
2subject_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
3subject_name VARCHAR(20) NOT NULL,
4level_of_entry VARCHAR(5),
5exam_board VARCHAR(10) NOT NULL,
6PRIMARY KEY (subject_id))