作者在 2012-08-09 11:25:04 发布以下内容
输入三个参数
1.存入A表的name的值
2.存入B表的name的值
3.存入B表的name的值
需求，B表为A表的子表,B表中有a_pk字段为a的主键
1.存入A表的name的值
2.存入B表的name的值
3.存入B表的name的值
需求，B表为A表的子表,B表中有a_pk字段为a的主键
drop procedure if exists test_a//
create procedure test_a(in a_name char,in b_name1 char,in b_name2 char)
begin
DECLARE ppId int(12);
delete from B;
delete from A;
insert into A(name) values(a_name);
set ppId=@@identity;
insert into B(name,a_pk) values(b_name1,ppId);
insert into B(name,a_pk) values(b_name2,ppId);
end
//
set @a_name='a'//
set @b_name1='b'//
set @b_name2='c'//
call test_a(@a_name,@b_name1,@b_name2)//
create procedure test_a(in a_name char,in b_name1 char,in b_name2 char)
begin
DECLARE ppId int(12);
delete from B;
delete from A;
insert into A(name) values(a_name);
set ppId=@@identity;
insert into B(name,a_pk) values(b_name1,ppId);
insert into B(name,a_pk) values(b_name2,ppId);
end
//
set @a_name='a'//
set @b_name1='b'//
set @b_name2='c'//
call test_a(@a_name,@b_name1,@b_name2)//
