[Err] 1172

1 错误描述

[Err] 1172 - Result consisted of more than one row


Procedure execution failed
1172 - Result consisted of more than one row

2 错误原因

   存储过程里,将查询的结果插入到一个临时表中,但是查询的数据条数超过一条,导致报错


3 解决办法

  修改存储过程中的查询语句,限制查询的记录数每次只有一条

原文地址:https://www.cnblogs.com/hzcya1995/p/13314476.html