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

1 错误描述

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


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

2 错误原因

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

3 解决办法

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