摘要: --创建表格 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) 阅读全文
posted @ 2012-08-03 14:48 HolyKnight 阅读(427) 评论(0) 推荐(0) 编辑