MySQL使用LAST_INSERT_ID()获取新插入记录的ID

0

<script language="javascript" type="text/javascript" src="http://static.bshare.cn/b/buttonLite.js#style=-1&amp;uuid=23a3475a-b05e-4ee9-bea7-b3336a11ccf6&amp;pophcol=2&amp;lang=zh"></script><script language="javascript" type="text/javascript" src="http://static.bshare.cn/b/bshareC2.js"></script>

MySQL：

delimiter // CREATE PROCEDURE P__Test_Insert( out nUserId int, in strAlias varchar(100), in strPwd varchar(100) ) Begin if not exists(select * from _User where UserName = strAlias) then insert into _User(UserName, PassWord, CreateTime) values(strAlias, strPwd, now()); set nUserId = LAST_INSERT_ID(); end if; End

前提：ID字段需设置为AUTO_INCREMENT。