~~~
CREATE DATABASE test
CREATE TABLE book (
BookNO int PRIMARY KEY,
BookName varchar(50) NOT NULL,
Author varchar(50) ,
Publishment varchar(50),
ButTime varchar(50) ,
Borrowed varchar(50),
Ordered varchar(50) )
INSERT INTO book VALUES (10001,'oracle快速入門','王海亮','水利出版社','2003.1.12','否','否');
INSERT INTO book VALUES (10002,'數據庫項目案例','周興華','清華出版社','2003.3.16','否','否');
INSERT INTO book VALUES (10003,'大學英語','王海','外文出版社','2007.1.12','否','否');
INSERT INTO book VALUES (10004,'體育','張亮','體育出版社','2003.1.12','否','否');
INSERT INTO book VALUES (10005,'英語大全','jeans','外文出版社','2003.1.12','否','否');
INSERT INTO book VALUES (10006,'計算機網絡','謝希任','高教出版社','2003.11.04','否','否');
INSERT INTO book VALUES (10007,'考驗英語','李陽','文化出版社','2003.3.12','否','否');
INSERT INTO book VALUES (10008,'數值分析','王文超','實踐出版社','2008.1.15','否','否');
INSERT INTO book VALUES (10009,'java me','秦一杰','人民郵電出版社','2004.1.12','否','否');
INSERT INTO book VALUES (10010,'思想理論','吳俊','同濟大學出版社','2003.1.12','否','否');
select * from book
CREATE TABLE exceedtime (
StuNO int NOT NULL DEFAULT '0' ,
BookNO int DEFAULT NULL,
BookName varchar(50) DEFAULT '',
DelayTime int,
PRIMARY KEY (StuNO,BookName))
INSERT INTO exceedtime VALUES (10001,10001,'oracle快速入門',50);
INSERT INTO exceedtime VALUES (10002,10002,'數據庫項目案例',50);
INSERT INTO exceedtime VALUES (10003,10001,'oracle快速入門',50);
INSERT INTO exceedtime VALUES (10004,10002,'數據庫項目案例',50);
select * from exceedtime
CREATE TABLE losebook (
LBNO int NOT NULL,
StuNO int DEFAULT NULL,
BookNO int DEFAULT NULL,
BookName varchar(50) DEFAULT NULL,
PRIMARY KEY (LBNO) )
CREATE TABLE manager (
mgNo int NOT NULL,
permitted varchar(50) DEFAULT NULL,
password varchar(50) DEFAULT NULL,
PRIMARY KEY (mgNo))
INSERT INTO manager VALUES (1001,'1','1001');
select * from manager
CREATE TABLE orderreport (
BookNO int NOT NULL,
StuName varchar(50) DEFAULT NULL,
Class varchar(50) DEFAULT NULL,
BookName varchar(50) DEFAULT NULL,
StuNO int DEFAULT NULL,
Author varchar(50) DEFAULT NULL,
PRIMARY KEY (BookNO) )
CREATE TABLE record (
BookNO int NOT NULL,
StuNO int DEFAULT NULL,
BorrowTime varchar(50) DEFAULT NULL,
ReturnTime varchar(50) DEFAULT NULL,
Borrowed varchar(50) DEFAULT NULL,
Ordered varchar(50) DEFAULT NULL,
PRIMARY KEY (BookNO))
CREATE TABLE student (
StuNO int NOT NULL,
StuName varchar(50) DEFAULT NULL,
StuAge int DEFAULT NULL,
StuSex varchar(50) DEFAULT NULL,
Class varchar(50) DEFAULT NULL,
Department varchar(50) DEFAULT NULL,
Tel char(11) DEFAULT NULL,
Permitted varchar(50) DEFAULT NULL,
Password varchar(20) DEFAULT NULL,
PRIMARY KEY (StuNO) )
INSERT INTO student VALUES (10001,'陳小詩',20,'女','計算機1班','計算機系','2592921','是','number1');
INSERT INTO student VALUES (10002,'李飛',21,'女','計算機1班','計算機系','13730120123','是','number2');
INSERT INTO student VALUES (10003,'孫亞',20,'男','計算機1班','計算機系','13633654578','是','number3');
INSERT INTO student VALUES (10004,'何二',22,'男','計算機1班','計算機系','2568975','是','number4');
INSERT INTO student VALUES (10005,'唐雨',21,'女','計算機1班','計算機系','13936968956','是','number5');
INSERT INTO student VALUES (10006,'宋江',20,'男','計算機2班','計算機系','1234667','是','number6');
select * from student
~~~
