NOT NULL

CREATE TABLE IF NOT EXISTS `teacher`(
	`teacher_id` CHAR(12) NOT NULL,
	`teacher_name` VARCHAR(40) NOT NULL,
	`teacher_dept` VARCHAR(4) NOT NULL,
	`teacher_phone` CHAR(11) NOT NULL
);

Last updated