手把手教你：创建innodb存储、gbk字符集的schooldb数据库及四张核心表！

CREATE DATABASE schooldb DEFAULT CHARACTER SET gbk; USE schooldb; CREATE TABLE teacher ( teacher_no VARCHAR(10) PRIMARY KEY, teacher_name VARCHAR(10) NOT NULL, teacher_contact VARCHAR(20) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=gbk; CREATE TABLE class ( class_no INT AUTO_INCREMENT PRIMARY KEY, class_name VARCHAR(30) NOT NULL UNIQUE, department_name VARCHAR(20) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=gbk; CREATE TABLE course ( course_no INT AUTO_INCREMENT PRIMARY KEY, course_name VARCHAR(10) NOT NULL, up_limit INT DEFAULT 60, description TEXT NOT NULL, status VARCHAR(6) DEFAULT '未审核', teacher_no VARCHAR(10) NOT NULL UNIQUE ) ENGINE=InnoDB DEFAULT CHARSET=gbk; CREATE TABLE student ( student_no VARCHAR(11) PRIMARY KEY, student_name VARCHAR(20) NOT NULL, student_contact VARCHAR(20), class_no INT ) ENGINE=InnoDB DEFAULT CHARSET=gbk; ######[AI写代码神器 | 617点数解答 | 2024-11-04 11:50:10]