MySQL上机考试题(习题-答案).doc

文档介绍：NurfürdenpersönlichenfürStudien,Forschung,(答案)建表详情:/*NavicatMySQLDataTransferSourceServer:rootSourceServerVersion:50067SourceHost:localhost:3306SourceDatabase:productTargetServerType:MYSQLTargetServerVersion:50067FileEncoding:65001Date:2013-02-2117:22:07*/SETFOREIGN_KEY_CHECKS=0;--------------------------------Tablestructurefor`pros`------------------------------DROPTABLEIFEXISTS`pros`;CREATETABLE`pros`(`产品编号`varchar(20)NOTNULL,`产品名称`varchar(50)NOTNULL,`价格`decimal(10,2)NOTNULL,`库存量`int(11)defaultNULL,PRIMARYKEY(`产品编号`))ENGINE=InnoDBDEFAULTCHARSET=gbk;--------------------------------Recordsofpros------------------------------INSERTINTO`pros`VALUES('0001','风筝','','1024');INSERTINTO`pros`VALUES('0002','杯子','','800');INSERTINTO`pros`VALUES('0003','帽子','','980');INSERTINTO`pros`VALUES('0004','项链','','266');INSERTINTO`pros`VALUES('0005','钻戒','','520');INSERTINTO`pros`VALUES('0112358','洗发露','','420');INSERTINTO`pros`VALUES('0112478','毛巾','','210');INSERTINTO`pros`VALUES('0112568','棉被','','300');INSERTINTO`pros`VALUES('0112690','墨水','','800');INSERTINTO`pros`VALUES('0112691','钢笔','','128');INSERTINTO`pros`VALUES('0112965','毛笔','','480');INSERTINTO`pros`VALUES('0221545','枕头','','520');--------------------------------Tablestructurefor`pro_sal`------------------------------DROPTABLEIFEXISTS`pro_sal`;CREATETABLE`pro_sal`(`销售日期`MENT'销售产品的日期',`产品编号`varchar(20)NOTNULL,`销售商编号`varchar(20)NOTNULL,`数量`int(11)NOTNULL,`销售额`decimal(10,0)NOTNULL,PRIMARYKEY(`产品编号`,`销售商编号`),KEY`销售商编号`(`销售商编号`),CONSTRAINT`销售商编号`FOREIGNKEY(`销售商编号`)REFERENCES`saler`(`销售商编号`),CONSTRAINT`产品编号`FOREIGNKEY(`产品编号`)REFERENCES`pros`(`产品编号`))ENGINE=InnoDBDEFAULTCHARSET=gbk;--------------------------------Recordsofpro_sal------------------------------INSERTINTO`pro_sal`VALUES('2013-02-06','0112358','000061','120','5890');INSERTINTO`pro_sal`VALUES('2013-02-18','0112690','037102','50','9853');INSERTINTO`pro_sal`V