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