1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54
| INSERT INTO TReader VALUES('131101','王林',1,'1996-2-10','计算机',4,null), ('131102','程明',1,'1997-2-1','计算机',2,null), ('131103','王燕',0,'1995-10-6','计算机',1,null), ('131104','韦严平',1,'1996-8-26','计算机',4,null), ('131106','李方方',1,'1996-11-20','计算机',1,null), ('131107','李明',1,'1996-5-1','计算机',0,null), ('131108','林一帆',1,'1995-8-5','计算机',0,null), ('131109','张强民',1,'1995-8-11','计算机',0,null), ('131110','张蔚',0,'1997-7-22','计算机',0,null), ('131111','赵琳',0,'1996-3-18','计算机',0,null), ('131113','严红',0,'1995-8-11','计算机',0,null), ('131201','王敏',1,'1995-6-10','通信工程',1,null), ('131202','王林',1,'1995-1-29','通信工程',1,null), ('131203','王玉民',1,'1996-3-26','通信工程',1,null), ('131204','马琳琳',0,'1995-2-10','通信工程',1,null), ('131206','李计',1,'1995-9-20','通信工程',1,null), ('131210','李红庆',1,'1995-5-1','通信工程',1,null), ('131216','孙祥欣',1,'1995-3-19','通信工程',0,null), ('131218','孙研',1,'1996-10-9','通信工程',1,null), ('131220','吴薇华',0,'1996-3-18','通信工程',1,null), ('131221','刘燕敏',0,'1995-11-12','通信工程',1,null), ('131241','罗林琳',0,'1996-1-30','通信工程',0,null)
INSERT INTO TBook Values('978-7-121-23270-1','MySQL实用教程(第2版)','郑阿奇','电子工业出版社','53',8,1,null,null), ('978-7-81124-476-2','S7-300/400可编程控制器原理与应用','崔维群 孙启法','北京航空航天大学出版社','59',4,1,null,null), ('978-7-111-21382-6','Java编程思想','Bruce Eckel','机械工业出版社','108',3,1,null,null), ('978-7-121-23402-6','SQL Server实用教程(第4版)','郑阿奇','电子工业出版社','59',8,5,null,null), ('978-7-302-10853-6','C程序设计(第三版)','谭浩强','清华大学出版社','26',10,7,null,null), ('978-7-121-20907-9','C#实用教程(第2版)','郑阿奇','电子工业出版社','49',6,3,null,null)
insert into TLend values ('1200001','131101','978-7-121-23270-1','2014-02-18'), ('1300001','131101','978-7-81124-476-2','2014-02-18'), ('1200002','131102','978-7-121-23270-1','2014-02-18'), ('1400030','131104','978-7-121-23402-6','2014-02-18'), ('1600011','131101','978-7-302-10853-6','2014-02-18'), ('1700062','131104','978-7-121-20907-9','2014-02-19'), ('1200004','131103','978-7-121-23270-1','2014-02-20'), ('1200003','131201','978-7-121-23270-1','2014-03-10'), ('1300002','131202','978-7-81124-476-2','2014-03-11'), ('1200005','131204','978-7-121-23270-1','2014-03-11'), ('1400031','131206','978-7-121-23402-6','2014-03-13'), ('1600013','131203','978-7-302-10853-6','2014-03-13'), ('1700064','131210','978-7-121-20907-9','2014-03-13'), ('1300003','131216','978-7-81124-476-2','2014-03-13'), ('1200007','131218','978-7-121-23270-1','2014-04-08'), ('1800001','131220','978-7-111-21382-6','2014-04-08'), ('1200008','131221','978-7-121-23270-1','2014-04-08'), ('1400032','131101','978-7-121-23402-6','2014-04-08'), ('1700065','131102','978-7-121-20907-9','2014-04-08'), ('1600014','131104','978-7-302-10853-6','2014-07-22'), ('1800002','131104','978-7-111-21382-6','2014-07-22')
|