I want to make a trigger that has a SELECT statement in it, but the SELECT query returns more than one row, so how can I handle multiple rows in triggers and loops that are built in MySql?
Please help me. : Jimit
It depends on what you want to do with the results SELECT , but the most general approach would be to use cursor .
SELECT