标签:
表
-- ----------------------------
-- Table structure for a
-- ----------------------------
DROP TABLE IF EXISTS `a`;
CREATE TABLE `a` (
`type` varchar(255) DEFAULT NULL,
`name` varchar(255) DEFAULT NULL,
`val` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of a
-- ----------------------------
INSERT INTO `a` VALUES (‘x‘, ‘A‘, ‘1‘);
INSERT INTO `a` VALUES (‘x‘, ‘B‘, ‘2‘);
INSERT INTO `a` VALUES (‘x‘, ‘C‘, ‘2‘);
INSERT INTO `a` VALUES (‘x‘, ‘A‘, ‘4‘);
INSERT INTO `a` VALUES (‘y‘, ‘B‘, ‘5‘);