nadeemshafi9 Posted June 15, 2007 Share Posted June 15, 2007 Hello Guys I just found out how to use stored proceedures instead of an Sql Statement, this is because i need to learn it forthe type of jobs im going for. Why do we need stored proceedures and what are there benifits ? Thanks Nadeem Quote Link to comment Share on other sites More sharing options...
akitchin Posted June 15, 2007 Share Posted June 15, 2007 an article that might be of interest: http://www.databasejournal.com/features/mysql/article.php/3525581 Quote Link to comment Share on other sites More sharing options...
nadeemshafi9 Posted June 15, 2007 Author Share Posted June 15, 2007 Thanks V much Quote Link to comment Share on other sites More sharing options...
bubblegum.anarchy Posted June 15, 2007 Share Posted June 15, 2007 Probably one of the best aspects of MySQL procedures is the ability to move all the common database abstraction done in php (or whatever language) back to the more appropriate location of MySQL. So instead of a php file that contains a common function to return account details, the same function can be defined in a procedure and used simply in php or any other language base. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.