据我所知mysql 不支持insert output 的方式,如果你是用到了auto_increment 然后插入多条的话,可以使用触发器 create table t1 (ID int auto_increment primary key,Col1 varchar(50)); create table t2 (ID int auto_increment primary key,t1id int); create table t3 (ID int auto_increment primary key,t2id int);delimiter // create trigger TR_t1 after insert on t1 for each row begin insert into t2(t1id) values(new.id); end// delimiter ;delimiter // create trigger TR_t2 after insert on t2 for each row begin insert into t3(t2id) values(new.id); end// delimiter ;insert into t1 (Col1) select 'A' union all select 'V' union all select 'S';select * from t1; select * from t2; select * from t3;
表二:id
表三:表一.id ,表二.id
现在就是增加多条数据如:表一.id,表二.id1;
表一.id,表二.id2;
表一.id,表二.id3:
..............
create table t1 (ID int auto_increment primary key,Col1 varchar(50));
create table t2 (ID int auto_increment primary key,t1id int);
create table t3 (ID int auto_increment primary key,t2id int);delimiter //
create trigger TR_t1 after insert on t1 for each row
begin
insert into t2(t1id) values(new.id);
end//
delimiter ;delimiter //
create trigger TR_t2 after insert on t2 for each row
begin
insert into t3(t2id) values(new.id);
end//
delimiter ;insert into t1 (Col1)
select 'A' union all
select 'V' union all
select 'S';select * from t1;
select * from t2;
select * from t3;