输入三个参数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)beginDECLARE ppId int(12);delete from B;delete from A;insert into A(name) values(a_name);set ppId=@@identity;insert int...