Example of nested cursors( 3 level deep) (no replies)
(MySQL.com) Here is an example of nested cursor showing parent,child & subchild relation.
The table is : mnudemo(id,nme,pid) where pid is the parent id.
DELIMITER $$
CREATE PROCEDURE 'mnu_demo_proc'()
BEGIN
declare c1id int;
decl
Update update feed set failed_fetches=0, fetched=current_timestamp() where feed_id = 1268 failed: 1142 [UPDATE command denied to user '334187_hdlns_ms5'@'10.187.248.89' for table 'feed'] in [update feed set failed_fetches=0, fetched=current_timestamp() where feed_id = 1268]
updated 1268 (MySQL User Forums), inserted 30, updated 0, at 2012-06-01 20:00:04
