mysql 课堂练习（截止自、内，外连接）

CREATE DATABASE lib2MngDatebase
ON
(
	NAME="libMngInfo",
	FILENAME='D:\libMngDB\libMngInfo.mdf',
	SIZE=5MB,
	MAXSIZE=20MB,
	FILEGROWTH=2KB
),
(
	NAME="libMngInfoN",
	FILENAME='D:\libMngDB\libMngInfo.ndf',
	SIZE=3MB,
	MAXSIZE=20MB,
	FILEGROWTH=2KB
)
LOG ON
(
	NAME="libMngInfoL",
	FILENAME='D:\libMngDB\libMngInfo.ldf',
	SIZE=3MB,
	MAXSIZE=20MB,
	FILEGROWTH=2KB
)
USE lib2MngDatebase
--创建图书管理库的图书、读者和借阅三个基本表的表结构：
--创建BOOK:（图书表）
 CREATE TABLE BOOK (
 BOOK_ID int,
 SORT VARCHAR(10),
 BOOK_NAME VARCHAR(50),
 WRITER VARCHAR(10),
 OUTPUT VARCHAR(50),
 PRICE int); 
--创建READER:（读者表）
CREATE TABLE READER (
READER_ID int,
COMPANY VARCHAR(10),
NAME VARCHAR(10),
SEX VARCHAR(2),
GRADE VARCHAR(10),
ADDR VARCHAR(50)); 
--创建BORROW:（借阅表）
CREATE  TABLE  BORROW (
 READER_ID  int,
 BOOK_ID  int,
 BORROW_DATE  date)
--插入数据:
--BOOK表:
insert into BOOK values(445501,'TP3/12','数据库导论','王强','科学出版社',17.90);
insert into BOOK values(445502,'TP3/12','数据库导论','王强','科学出版社',17.90);
insert into BOOK values(445503,'TP3/12','数据库导论','王强','科学出版社',17.90);
insert into BOOK values(332211,'TP5/10','计算机基础','李伟','高等教育出版社',18.00);
insert into BOOK values(112266,'TP3/12','FoxBASE','张三','电子工业出版社',23.60);
insert into BOOK values(665544,'TS7/21','高等数学','刘明','高等教育出版社',20.00);
insert into BOOK values(114455,'TR9/12','线性代数','孙业','北京大学出版社',20.80);
insert into BOOK values(113388,'TR7/90','大学英语','胡玲','清华大学出版社',12.50);
insert into BOOK values(446601,'TP4/13','数据库基础','马凌云','人民邮电出版社',22.50);
insert into BOOK values(446602,'TP4/13','数据库基础','马凌云','人民邮电出版社',22.50);
insert into BOOK values(446603,'TP4/13','数据库基础','马凌云','人民邮电出版社',22.50);
insert into BOOK values(449901,'TP4/14','FoxPro大全','周虹','科学出版社',32.70);
insert into BOOK values(449902,'TP4/14','FoxPro大全','周虹','科学出版社',32.70);
insert into BOOK values(118801,'TP4/15','计算机网络','黄力钧','高等教育出版社',21.80);
insert into BOOK values(118802,'TP4/15','计算机网络','黄力钧','高等教育出版社',21.80);
--READER表:
insert into reader values(111,'信息系','王维利','女','教授','1号楼');
insert into reader values(112,'财会系','李 立','男','副教授','2号楼');
insert into reader values(113,'经济系','张 三','男','讲师','3号楼');
insert into reader values(114,'信息系','周华发','男','讲师','1号楼');
insert into reader values(115,'信息系','赵正义','男','工程师','1号楼');
insert into reader values(116,'信息系','李 明','男','副教授','1号楼');
insert into reader values(117,'计算机系','李小峰','男','助教','1号楼');
insert into reader values(118,'计算机系','许鹏飞','男','助工','1号楼');
insert into reader values(119,'计算机系','刘大龙','男','教授','1号楼'