procedure:CREATE DEFINER=`root`@`localhost` PROCEDURE `p1`(out last_id int)
BEGIN
INSERT INTO aaa(name) VALUES('ABC');
SET last_id = last_insert_id();
END$$--------------------------------------------------------php code:mysql_query("Call p1(@a)") or die(mysql_error());
$rs = mysql_query("SELECT @a");
while ($row = mysql_fetch_array($rs)) {
var_dump($row);
}
BEGIN
INSERT INTO aaa(name) VALUES('ABC');
SET last_id = last_insert_id();
END$$--------------------------------------------------------php code:mysql_query("Call p1(@a)") or die(mysql_error());
$rs = mysql_query("SELECT @a");
while ($row = mysql_fetch_array($rs)) {
var_dump($row);
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货