網(wǎng)上書店管理系統(tǒng)數(shù)據(jù)庫MySQL

新建數(shù)據(jù)庫CreatedatabaseBookData;UseBookData;新建表B1createtableTbl_Customer(Customerdecimalnotnull,Customer_Namevarchar(10),Addressvarchar(20),Cityvarchar(20),Statevarchar(20),Zipvarchar(6),Referreddecimal);插入數(shù)據(jù)insertintotbl_customervalues(1001,'張三','白下區(qū)','南京','江蘇','210000',null);insertintotbl_customervalues(1002,'李四','徐匯區(qū)','上海','上海','110000',null);insertintotbl_customervalues(1003,'王五','旭日區(qū)','北京','北京','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));插入數(shù)據(jù)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,'少兒');數(shù)據(jù)庫的實現(xiàn)','1999-06-04',3,31,55,'計算機');用蘑菇烹調(diào)','2000-02-28',4,,,'烹調(diào)');數(shù)據(jù)庫法寶','2001-11-30',3,47,75,'計算機');新建表B3createtableTbl_Orders(Ordersdecimal(4)notnull,Customerdecimal(4),OrderdateDate,ShipdateDate,Shipstreetvarchar(18),Shipcityvarchar(15),Shipstatevarchar(2),Shipzipvarchar(6));改正數(shù)據(jù)長度時用altertable表名modify字段名稱字段種類插入數(shù)據(jù)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));插入數(shù)據(jù)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));插入數(shù)據(jù)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插入數(shù)據(jù)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));插入數(shù)據(jù)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','機械工業(yè)第一版社','陸華','000-714-8751');新建表B8createtableTbl_Promotion(geftvarchar(100),minretaildecimal(5,2),maxretaildecimal(5,2));插入數(shù)據(jù)insertintoTbl_Promotionvalues('insertintoTbl_Promotionvalues('insertintoTbl_Promotionvalues('insertintoTbl_Promotionvalues('

書簽',0,12);書簽