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;