文档介绍：学海无涯MySQL上机考试题(答案)建表详情:/*NavicatMySQLDataTransferSourceServer :rootSourceServerVersion:50067SourceHostSourceDatabase:localhost:3306: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,1学海无涯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'销售产品的日期',`产品编号