Result consisted of more than one row

执行存储过程,  报错: Result consisted of more than one row
检查后发现: 某条SQL语句 
select ... into from tableName where ...
查询的结果有多条记录导致.
只要在这条语句后加一个限制即可:
select ... into from tableName where ... limit 1;