Re: New to sp, ERROR 1172 (42000): Result consisted of more than one row

[Per-Erik Martin]

The problem is probably this line:

SELECT pet.owner<>event.owner,event.name,pet.species INTO comp,name_id2,species_id2 FROM event,pet WHERE pet.name=event.name;

When using INTO variables, it must return exactly one row, but apparently it does not. Either make the WHERE select a unique row,
or use LIMIT 1 to enforce a single result (which assumes that you want the first one).

pem, Senior Software Dev., MySQL AB