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_id;
insert into t_b(b_name,a_id) values(p_bname,v_id);
end


ÉÏÃæµÄ´æ´¢¹ý³ÌÖ´ÐÐʱ£¬»á²»»á´æÔÚÕâÑùÒ»ÖÖ·çÏÕ£ºÓжà¸ö¿Í»§¶Ëͬʱµ÷Óô洢¹ý³Ì£¬´æ´¢¹ý³ÌÔÚÖ´ÐÐselect a_id into @v_id from t_a order by a limit 1;Õâ¾äʱ£¬»ñÈ¡µÄid»á²»»á´íλ£¿Ò²¾ÍÊÇ˵¶à¸ö¿Í»§¶Ëµ÷ÓÃͬһ¸öServerµÄͬһ¸ö´æ´¢³ÌÐò£¬´æ´¢³ÌÐòÊDz¢ÐÐÖ´Ðл¹ÊÇ˳ÐòÖ´ÐУ¿ÎÒÀí½âµÄ²¢ÐÐÖ´ÐоÍÊǶà¸ö³ÌÐòͬʱִÐУ¬Ë³ÐòÖ´ÐоÍÊÇÒ»¸öclient¶ËÍêÁËÔÙÖ´ÐÐÁíÒ»¸öclient¶ËµÄ£¬Ð»Ð»£¡

---

MySQL ²»±£Ö¤Äã²¢·¢½ø³ÌµÄ·ÃÎÊ˳Ðò£¡
Èç¹ûÄãÏëÈ¡¸ÕINSERTµÄa_id£¬×îºÃÓÃLAST_INSERT_ID()


insert into t_a(a_name)values(p_aname);
select LAST_INSERT_ID()¡¡into @v_id ;

---

LAST_INSERT_ID()ÊǸöfunction£¬ÎÒÔõô֪µÀÕâ¸öLAST_INSERT_ID()ÊÇt_aµÄ¶ø²»ÊÇt_bµÄÄØ£¿
ÈçºÎ¶¨Î»Õâ¸ö