mysql´æ´¢¹ý³Ì»ñµÃ²åÈëÊý¾ÝµÄ×ÔÔö³¤ID

CREATE DEFINER=`root`@`localhost` PROCEDURE `chat_user_adduer`(
in UN varchar(45),
in Psw varchar(50),
in NM varchar(45),
in se tinyint,
out Result int
)
BEGIN

insert into t_b_chatuser(username,password,name,sex)
values(UN,Psw,NM,se);

select Result=last_insert_id();

END
ΪʲôResultµÄÖµÊÇ0ÄØ£¿Ö´Ðкóȷʵ²åÈëÊý¾ÝÁË

---

¹ûÈ»£¬Ð»Ð»»Ø¸´

---

OR
SELECT @Result:=LAST_INSERT_ID();
SELECT @Result;

---

OR
SELECT Result:=LAST_INSERT_ID();
SELECT Result;

---

ÒýÓÃ

OR
SELECT Result:=LAST_INSERT_ID();
SELECT Result;

ÕâÀï²»ÄÜÖ±½ÓÓÃ=ÊÇÂð£¿:=ÕâÊÇʲôÒâ˼ÄØ£¿

---

ÒýÓÃ

ÕâÀï²»ÄÜÖ±½ÓÓÃ=ÊÇÂð£¿:=ÕâÊÇʲôÒâ˼ÄØ£¿

:= ÊǸ³ÖµµÄ²Ù×÷

---

ѧϰÁË£¬Ð»Ð»

---

Æäʵһ°ãµÄд·¨ÊÇ¡£

set Result=last_insert_id();