DEFAULT
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) DEFAULT "00099900099",
`teacher_email` CHAR(11) DEFAULT NULL
);
Last updated
Was this helpful?