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

MySQL上机考试题(答案)建表详情:/*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)N