Mysql如何写一个存储过程，同时向两张表里插入数据，有入参

Question

没写过mysql的存储过程，求指导，非常感谢！！！

Answer 1

自问自答，已经搞定，查了几篇文章
https://www.cnblogs.com/mark-...
https://www.cnblogs.com/phppe...

CREATE PROCEDURE proc123 (IN aaa char(100) , IN bbb char(100), IN cccchar(100) , IN dddchar(100) , IN eeechar(100) , IN fff char(100) )
BEGIN
insert into abc(aaa, bbb, ccc, dd,ee, ff, gg, yy,ss, qq ) values (aaa, bbb, '1','1', ccc, ddd, eee, fff,'1', '1');
insert into edf(aaa, bbb) values (aaa, bbb);
END

调用 call proc1128(aaa, bbb, ccc, ddd, eee, fff)

很简单的逻辑