Mysql存储过程的执行顺序问题
SQL code:
CREATE TABLE `t_a` (
`a_id` int(11) NOT NULL AUTO_INCREMENT,
`a_name` varchar(30) NOT NULL DEFAULT ‘N/A’,
PRIMARY KEY (`a_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `t_b` (
`b_id` int(11) NOT NULL AUTO_INCREMENT,
`b_name` varchar(30) NOT NULL DEFAULT ‘N/A’,
`a_id` int(11) NOT NULL DEFAULT ‘0’,
PRIMARY KEY (`b_id`),
KEY `a_id` (`a_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
create procedure sp_insert_b
(
p_aname varchar(30),
p_bname varchar(30)
)
begin
declare v_id int;
insert into t_a(a_name)values(p_aname);
select a_id into @v_id from t_a order by a limit 1;
set v_id=@v_i