Posted: Sat Oct 14, 2006 5:00 pm Post subject: writing store procedures in mysql
Writing store procedures in mysql is very easiest way. This is example that can be write in mysql query browser. create in procedure in my mysql query browser, add your logic what you want in your procedure.
easy store procedure example with loop are
DROP PROCEDURE IF EXISTS `webmaster`.`easyStoreProcedure`\\
CREATE PROCEDURE `webmaster`.`easyStoreProcedure` ()
select * from yourTableName;
This is simple store procedure, after this execute store procedure. If execute without errors, you can run this store procedure
Second example of store procedure is little difficult.