Re: triggers

[Andrew Dashin]

Hi, ch

Probably you should look here 
http://dev.mysql.com/doc/refman/5.0/en/cursors.html

-- 
Andrew Dashin


ch h пишет:
> In a trigger I need to iterate thru a query result that will consist of more than 1
> row. Could someone please give me a general example of how this would be accomplished. For
> example in php i would just use 
>   while($row = $result->fetch_assoc)
>   {
>   ......process the row....
>   }
>    
>   I have no idea how to do this with in the confines of a trigger.
>    
>   Thanks
>
>        
> ---------------------------------
> No need to miss a message. Get email on-the-go 
> with Yahoo! Mail for Mobile. Get started.
>