execute MySQL stored procedures

最新推荐文章于 2025-08-21 18:01:50 发布

多鱼的夏天

最新推荐文章于 2025-08-21 18:01:50 发布

阅读量879

点赞数

CC 4.0 BY-SA版权

文章标签： mysql url user server

本文链接：https://blog.youkuaiyun.com/hjue/article/details/5414904

本文介绍了如何修改连接标志以使MySQL客户端能够处理多个结果集的情况。当存储过程返回不确定数量的结果时，需要将CLIENT_MULTI_RESULTS标志设置为有效。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Since a stored procedure doesn't know ahead of time how many results will be returned, the client needs to support reading any multiple of results. Therefore, if the server sees that you don't have CLIENT_MULTI_RESULTS set, it will give an error saying that it can't return a result set in the given context. To fix this the following change must be made.

The code needs to be changed from:
$connection = @mysql_connect($url['host'], $url['user'], $url['pass'], TRUE, 2);
to:
$connection = @mysql_connect($url['host'], $url['user'], $url['pass'], TRUE, 131074);

This changes the flag at the end from CLIENT_FOUND_ROWS to (CLIENT_FOUND_ROWS | CLIENT_MULTI_RESULTS).