210223linux精品课程04阶段-数据库0-mysql课堂笔记sql.pdfVIP

CREATE DATABASE school CHARSET utf8; USE school; CREATE TABLE STUDENT ( SNO INT PR RY KEY, SNAME VARCHAR(10) NOT NULL, SAGE INT NOT NULL, SSEX CHAR(2) NOT NULL ); CREATE TABLE COURSE ( CNO INT PR RY KEY, CNAME VARCHAR(10) NOT NULL, TNO INT NOT NULL ); CREA