表books.sql

1.写出建立BORROW表的SQL语句

insert into BOOKS(BNO,BNAME,AUTHOR,PRICE,QUANTITY)
values ('1001','水浒', '施耐庵','32.5','100')
insert into BOOKS(BNO,BNAME,AUTHOR,PRICE,QUANTITY)
values ('1002', '网络技术','张尧学','24','56')
insert into BOOKS(BNO,BNAME,AUTHOR,PRICE,QUANTITY)
values ('1003','计算方法','洪京一','21','90')
insert into BOOKS(BNO,BNAME,AUTHOR,PRICE,QUANTITY)
values ('1004','计算方法习题集','曹洪波','19','18')
insert into BOOKS(BNO,BNAME,AUTHOR,PRICE,QUANTITY)
values ('1005', '网络基础', '池成','19','130')
insert into BOOKS(BNO,BNAME,AUTHOR,PRICE,QUANTITY)
values ('1006', '网络管理','石枫','16','80')
insert into BOOKS(BNO,BNAME,AUTHOR,PRICE,QUANTITY)
values ('1007', '网络游戏开发','管志中','10','70')
insert into BOOKS(BNO,BNAME,AUTHOR,PRICE,QUANTITY)
values ('1008', '组合数学','许文丹','36','200')
insert into BOOKS(BNO,BNAME,AUTHOR,PRICE,QUANTITY)
values ('1009', '大学英语','田娟','22','40')