摘要:
--创建表格 CREATE TABLE STUDENT( STUDENT_ID CHAR(5) NOT NULL PRIMARY KEY, NAME VARCHAR(20) UNIQUE, GENDER CHAR(10) DEFAULT('MALE'), BIRTHDAY INT, SDEPT VARCHAR(15));--创建索引create index student_name on student(name)create table course( cno char(4) not null primary key, cname char(40), cpno char(4) 阅读全文