+-
MySQL错误#2014 – 命令不同步;你现在不能运行这个命令
我正在使用 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 get Commands out of sync; you
can't run this command now
in your client code, you are calling client
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 called mysql_free_result().
It can also happen if you try to execute two queries that return data
without calling mysql_use_result() or mysql_store_result() in between.

这篇文章(摘自here)

I’ve solved that problem. I use MySQL-Fron instead MySQL Query
browser. And everything works fine.

让我觉得它不是服务器或数据库问题,而是您正在使用的工具中的问题.

点击查看更多相关文章

转载注明原文:MySQL错误#2014 – 命令不同步;你现在不能运行这个命令 - 乐贴网