mysql 插入两张表_mysql 自动插入两张表管理sql

DROP TABLE IF EXISTS `t_test`;

CREATE TABLE `t_test` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`name` varchar(64) DEFAULT NULL,

`pid` int(11) DEFAULT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------

-- Records of t_test

-- ----------------------------

INSERT INTO `t_test` VALUES ('1', 'zhangshan', '12');

-- ----------------------------

-- Table structure for `t_test1`

-- ----------------------------

DROP TABLE IF EXISTS `t_test1`;

CREATE TABLE `t_test1` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`m` varchar(32) DEFAULT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

-- ----------------------------

-- Records of t_test1

-- ----------------------------

INSERT INTO `t_test1` VALUES ('12', 'code');

INSERT INTO `t_test` (`name`,`pid`)

SELECT 'zhangshan1',

(SELECT id FROM `t_test1` WHERE m = 'code');