MySQL Trigger With SELECT Statement

Question

I want to make trigger that having SELECT Statement in it but that SELECT query returns more than one rows so, How can I handle that multiple rows in trigger and looping that rows in MySql?

Please Help me. :Jimit

James McNellis · Accepted Answer · 2010-05-05 16:08:39Z

4

It depends on exactly what you want to do with the results of the SELECT, but the most general approach would be to use a cursor.

answered May 5, 2010 at 16:08

James McNellis

357k76 gold badges934 silver badges983 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MySQL Trigger With SELECT Statement

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related