MySQL 上机考试题（答案）建表详情：/*NavicatMySQLDataTransferSourceServer:rootSourceServerVersion:50067SourceHostSourceDatabase:localhost:3306:productTargetServerType:MYSQLTargetServerVersion:50067: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;--RecordsofprosINSERTINTO'pros'VALUES('0001','风筝'，'18.80','1024');INSERTINTO'pros'VALUES('0002','杯子',990','800');INSERTINTO'pros'VALUES('0003','帽子','19.80','980');INSERTINTO'pros'VALUES('0004','项链','9868.99','266');INSERTINTO'pros'VALUES('0005','钻戒'，'18999.68','520');INSERTINTO'pros'VALUES('0112358','洗发露'，'20.59','420');INSERTINTO'pros'VALUES('0112478','毛巾'，650','210');INSERTINTO'pros'VALUES('0112568','棉被'，'200.86','300');INSERTINTO'pros'VALUES('0112690','墨水'，'5.50','800');INSERTINTO'pros'VALUES('0112691','钢笔'，'86.99','128');INSERTINTO'pros'VALUES('0112965','毛笔'，'35.48','480');INSERTINTO'pros'VALUES('0221545','枕头'，'63.68','520');--Tablestructurefor、pro_sal'DROPTABLEIFEXISTS'pro_sal';CREATETABLE'pro_sal'('销售日期'dateNOTNULLCOMMENT 销售产品的日期','产品编号'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_salINSERTINTO、pro_sal、VALUES('2013-02-06','0112358','000061','120','5890');INSERTINTO、pro_sal、VALUES('2013-02-18','0112690','037102','50','9853');INSERTINTO、pro_sal、VALUES('2013-02-04','0112691','087412','15','1421');--Tablestructurefor'saler'DROPTABLEIFEXISTS'saler';CREATETABLE'saler'('销售商编号'va...
