文档介绍:MySQL上机考试题(答案)
建表详情:
/*
NavicatMySQLDataTransfer
SourceServer :root
SourceServerVersion:50067
SourceHost :localhost:3306
SourceDatabase :product
TargetServerType :MYSQL
TargetServerVersion:50067
:65001
Date: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`(
`销售日期`MEN