表borrow.sql

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

insert into BORROW(CNO,BNO,RDATE)
values ('22000501','1002','2007-5-11')
insert into BORROW(CNO,BNO,RDATE)
values('22000501','1003','2007-6-25')
insert into BORROW(CNO,BNO,RDATE)
values('22000501','1004','2007-6-3')
insert into BORROW(CNO,BNO,RDATE)
values('22000502','1001','2007-5-24')
insert into BORROW(CNO,BNO,RDATE)
values('33000504','1001','2007-6-1')
insert into BORROW(CNO,BNO,RDATE)
values ('44000501','1001','2007-7-02')
insert into BORROW(CNO,BNO,RDATE)
values('22000504','1006','2007-4-2')
insert into BORROW(CNO,BNO,RDATE)
values('33000501','1007','2007-3-7')
insert into BORROW(CNO,BNO,RDATE)
values('22000504','1008','2007-4-1')
insert into BORROW(CNO,BNO,RDATE)
values('33000503','1003','2007-9-20')
insert into BORROW(CNO,BNO,RDATE)
values('33000503','1005','2007-8-10')
insert into BORROW(CNO,BNO,RDATE)
values('33000503','1006','2007-6-12')
insert into BORROW(CNO,BNO,RDATE)
values('33000503','1002','2007-8-7')
insert into BORROW(CNO,BNO,RDATE)
values('33000503','1008','2007-7-7')
insert into BORROW(CNO,BNO,RDATE)
values('33000501','1003','2007-06-5')
insert into BORROW(CNO,BNO,RDATE)
values('22000503','1003','2007-05-28')
insert into BORROW(CNO,BNO,RDATE)
values('22000501','1008','2007-5-2')
insert into BORROW(CNO,BNO,RDATE)
values('33000501','1008','2007-5-14')