存储过程导致“命令不同步".在下一个查询 [英] Stored procedure causes "Commands out of sync" on the next query

问题描述

我正在使用mysql存储过程运行查询:

I am running a query with a mysql stored procedure :

$AddProf_qr = mysql_query("call AddStudent('$d_Pass', '$d_Titl', '$d_Firs', '$d_Midd',  '$d_Last', '$d_Addr', '$d_City', '$d_Stat', '$d_County',  '$d_Zipc', $d_Gend, '$d_Birh', '$d_Phom', '$d_Phoh', '$d_Phoo', '$d_Email', '$d_Webs', '$d_Natn', '$d_Profsn',  '$d_Compny', '$d_Desig', $d_ProfAcc)", $this->c_remote) or die ("first call" . mysql_error($this->c_remote));

我应该从通话中得到一个结果:@@ IDENTITY =一个数字；

I am supposed to get just one result from the call : @@IDENTITY = a number;

$AP_result = mysql_fetch_array($AddProf_qr);
$CurrentSID = $AP_result['@@IDENTITY'];

效果很好.但是当我在此之后立即运行另一个mysql更新查询时，它给出了一条错误消息:

which works fine. but when i run another mysql update query right after this, it gives an error saying :

错误:2014年(CR_COMMANDS_OUT_OF_SYNC) 消息:命令不同步；您现在不能运行此命令

Error: 2014 (CR_COMMANDS_OUT_OF_SYNC) Message: Commands out of sync; you can't run this command now

我尝试插入:

mysql_free_result($AddProf_qr);

但仍然相同.

MySQL调用也可以正常执行 脚本的其余部分运行无任何问题，以上内容已被注释掉.但它们不能同时运行.我最好的猜测是，电话正在做的事情弄糟了这一点.

The MySQL call executes fine also the rest of the script runs without issues the above is commented out. but they don't run at the same time. My best guess is, the call is doing something that's messing this up.

推荐答案

您的存储过程将返回多个结果集.参见这篇文章

Your stored procedure is returning multiple resultsets. See this post

解决方案?

• 使用 mysqli_multi_query
• 有充分的理由停止使用古老的mysql库-mysqli中的i代表改进".

这篇关于存储过程导致“命令不同步".在下一个查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！