我想了一种方法,如果在a中还有一个字段a_time,b中也有个字段b_time,a_time=b_time,可以先取得a_time的值
create procedure
@tim
insert into a(a_name,a_time) value("myname",@time);
insert into b(a_id,b_name,b_time) values select a_id,'mybame',@time from a where a_time=@time
在new_sql 环境下:
先把这条记录插入一个空临时表中:他t_temptable(id1,name1,id1,name2 valuename,....)第然后:
insert into a(id,a_name) as select id1,name1 from t_temptable;
insert into b (id,a_id,b_name,b_value) as select id2,id1,name2,valuename from t_temptable;
这样就轻松ok了!