网上书店管理系统数据库MySQL

新建数据库CreatedatabaseBookData;UseBookData;新建表B1createtableTbl_Customer(Customerdecimalnotnull,Customer_Namevarchar(10),Addressvarchar(20),Cityvarchar(20),Statevarchar(20),Zipvarchar(6),Referreddecimal);插入数据insertintotbl_customervalues(1001,'张三','白下区','南京','江苏','210000',null);insertintotbl_customervalues(1002,'李四','徐汇区','上海','上海','110000',null);insertintotbl_customervalues(1003,'王五','旭日区','北京','北京','110000',null);insertintotbl_customervalues(1004,'赵六','北大街','无锡','江苏','110000',null);insertintotbl_customervalues(1005,'李三','平江路','苏州','江苏','110000',null);insertintotbl_customervalues(1006,'陈三','升州路','南京','江苏','110000',null);insertintotbl_customervalues(1007,'朱三','三牌楼','合肥','安徽','110000',1003);新建表B2createtableTbl_Books(Isbnvarchar(10)notnull,Titlevarchar(300),PubdateDate,Pubiddecimal(2),Costsdecimal(5,2),Retaildecimal(5,2),Categorysvarchar(12));插入数据insertintotbl_booksvalues('98','insertintotbl_booksvalues('03','insertintotbl_booksvalues('10','insertintotbl_booksvalues('13','insertintotbl_booksvalues('90','insertintotbl_booksvalues('68','

一天中10分钟的身体成分','2001-1-21',4,,,'健康');米奇的复仇','2001-12-12',1,,22,'家庭生活');用牙签造车','2002-08-18',2,,59,'少儿');数据库的实现','1999-06-04',3,31,55,'计算机');用蘑菇烹调','2000-02-28',4,,,'烹调');数据库法宝','2001-11-30',3,47,75,'计算机');新建表B3createtableTbl_Orders(Ordersdecimal(4)notnull,Customerdecimal(4),OrderdateDate,ShipdateDate,Shipstreetvarchar(18),Shipcityvarchar(15),Shipstatevarchar(2),Shipzipvarchar(6));改正数据长度时用altertable表名modify字段名称字段种类插入数据insertintoTbl_Ordersvalues(1000,1005,'2003-03-31','2003-04-02','奥体大街','南京','江苏','210019');insertintoTbl_Ordersvalues(1001,1010,'2003-03-31','2003-04-01','和会街','南京','江苏','210001');insertintoTbl_Ordersvalues(1002,1011,'2003-03-31','2003-04-01','南京路','上海','上海','201100');insertintoTbl_Ordersvalues(1003,1001,'2003-04-01','2003-04-01','南京路','上海','上海','201100');insertintoTbl_Ordersvalues(1004,1020,'2003-04-01','2003-04-05','欧风街','无锡','江苏','204002');新建表B4createtableTbl_Oraderitems(ordersdecimal(4)notnull,Itemdecimal(2)notnull,Isbnvarchar(10),quantitydecimal(3));插入数据insertintoTbl_Oraderitemsvalues(1000,1,'90',1);insertintoTbl_Oraderitemsvalues(1001,1,'01',1);insertintoTbl_Oraderitemsvalues(1001,2,'20',1);insertintoTbl_Oraderitemsvalues(1002,1,'32',2);insertintoTbl_Oraderitemsvalues(1003,1,'32',1);MySQL语句能够放在同一行；可是DB2不能够新建表B5createtableTbl_Author(AuthorIdvarchar(4)notnull,namevarchar(20));插入数据insertintoTbl_Authorvalues('s100','薛明');insertintoTbl_Authorvalues('j100','陈洪');insertintoTbl_Authorvalues('a100','张二');insertintoTbl_Authorvalues('m100','刘虎');insertintoTbl_Authorvalues('k100','陈康');新建表B6createtableTbl_BookAuthor(Isbnvarchar(10)notnull,AuthorIdvarchar(4)notnull);droptableTbl_BookAuthor插入数据insertintoTbl_BookAuthorvalues('98','s100');insertintoTbl_BookAuthorvalues('98','p100');insertintoTbl_BookAuthorvalues('03','j100');insertintoTbl_BookAuthorvalues('10','k100');insertintoTbl_BookAuthorvalues('13','p105');insertintoTbl_BookAuthorvalues('13','a100');insertintoTbl_BookAuthorvalues('13','a105');insertintoTbl_BookAuthorvalues('90','b100');insertintoTbl_BookAuthorvalues('68','a100');insertintoTbl_BookAuthorvalues('92','w100');insertintoTbl_BookAuthorvalues('92','w105');insertintoTbl_BookAuthorvalues('21','j100');insertintoTbl_BookAuthorvalues('20','r100');insertintoTbl_BookAuthorvalues('20','f100');insertintoTbl_BookAuthorvalues('20','b100');insertintoTbl_BookAuthorvalues('09','s100');insertintoTbl_BookAuthorvalues('91','r100');insertintoTbl_BookAuthorvalues('01','s100');insertintoTbl_BookAuthorvalues('01','w100');insertintoTbl_BookAuthorvalues('90','w105');新建表B7createtableTbl_Publisher(Pubidvarchar(10)notnull,Namevarchar(23),ContactVarchar(15),Phonevarchar(12));插入数据insertintoTbl_Publishervalues('1','新华第一版社','程明','000-714-8321');insertintoTbl_Publishervalues('2','扬子第一版社','张译','0');insertintoTbl_Publishervalues('3','人民教育第一版社','园艺','044-714-8321');insertintoTbl_Publishervalues('4','北京大学第一版社','郑爽','000-564-8321');insertintoTbl_Publishervalues('5','机械工业第一版社','陆华','000-714-8751');新建表B8createtableTbl_Promotion(geftvarchar(100),minretaildecimal(5,2),maxretaildecimal(5,2));插入数据insertintoTbl_Promotionvalues('insertintoTbl_Promotionvalues('insertintoTbl_Promotionvalues('insertintoTbl_Promotionvalues('

书签',0,12);书签