数据库
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `table2`
-- ----------------------------
DROP TABLE IF EXISTS `table2`;
CREATE TABLE `table2` (
`a` varchar(10) DEFAULT NULL,
`c` varchar(10) DEFAULT NULL,
`d` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of table2
-- ----------------------------
INSERT INTO `table2` VALUES ('赵', '90', '5');
INSERT INTO `table2` VALUES ('钱', '100', '1');
INSERT INTO `table2` VALUES ('孙', '80', '2');
INSERT INTO `table2` VALUES ('李', null, '3');