文档介绍:MySQL上机考试题****题,答案
MySQL上机考试题****题,答案
1 / 10
MySQL上机考试题****题,答案
MySQL上机考试题(答案)
建表详情:
/*
Navicat MySQL Data Transfer
S / 10
MySQL上机考试题****题,答案
PRIMARY KEY (`产品编号`,`销售商编号`),
KEY `销售商编号` (`销售商编号`),
CONSTRAINT `销售商编号` FOREIGN KEY (`销售商编号`) REFERENCES `saler` (`销售商编号`),
CONSTRAINT `产品编号` FOREIGN KEY (`产品编号`) REFERENCES `pros` (`产品编号`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;
-- ----------------------------
-- Records of pro_sal
-- ----------------------------
INSERT INTO `pro_sal` VALUES ('2013-02-06', '0112358', '000061', '120', '5890');
INSERT INTO `pro_sal` VALUES ('2013-02-18', '0112690', '037102', '50', '9853');
INSERT INTO `pro_sal` VALUES ('2013-02-04', '0112691', '087412', '15', '1421');
-- ----------------------------
-- Table structure for `saler`
-- ----------------------------
DROP TABLE IF EXISTS `saler`;
CREATE TABLE `saler` (
`销售商编号` varchar(20) NOT NULL,
`销售商名称` varchar(50) NOT NULL,
`地区` varchar(10) NOT NULL COMMENT '销售商所有地',
`负责人` varchar(10) default NULL,
` ` varchar(20) default NULL,
PRIMARY KEY (`销售商编号`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;
-- ----------------------------
MySQL上机考试题****题,答案
MySQL上机考试题****题,答案
4 / 10
MySQL上机考试题****题,答案
-- Records of saler
-- ----------------------------
INSERT INTO `saler` VALUES ('000165', '喜田', '华北', '王总', '03254898684');
INSERT INTO `saler` VALUES ('059741', '成建股份', '