且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

SELECT .. INTO 返回多行 - Mysql

更新时间:2023-12-04 13:14:10

这是因为您将结果INTO"插入到一个变量中,并且因为结果不止一个值,因此出现了错误.

Its because you are inserting the result 'INTO' a variable and because the result is more than a single value, hence the error.

您的限制为 10,尝试更改为 1,这将解决它,如果您想要返回多个值,那么您需要在记录集中管理这些值.

You have a limit of 10, try changing to 1, that will fix it, if you want multiple values returned then you need to manage these in a recordset.