+-

我正在使用 MySQL,我正在定义一个这样的存储过程:
delimiter ;;
Create procedure sp_test()
select * from name_table;
end
当我尝试执行该过程时,我收到此错误:
#2014 - Commands out of sync; you can't run this command now
这意味着什么,我做错了什么?
最佳答案
从 Manual起
C.5.2.14. Commands out of sync
If you getCommands out of sync; youin your client code, you are calling client
can't run this command now
functions in the wrong order.This can happen, for example, if you are using
mysql_use_result()and
try to execute a new query before you have calledmysql_free_result().
It can also happen if you try to execute two queries that return data
without callingmysql_use_result()ormysql_store_result()in between.
这篇文章(摘自here)
I’ve solved that problem. I use MySQL-Fron instead MySQL Query
browser. And everything works fine.
让我觉得它不是服务器或数据库问题,而是您正在使用的工具中的问题.
点击查看更多相关文章
转载注明原文:MySQL错误#2014 – 命令不同步;你现在不能运行这个命令 - 乐贴网