Differences between Stored Procedures and Functions in MYSQL

1. Stored Procedure can return zero or n values whereas function can return one value which is mandatory.
2. Functions can be called from procedure whereas procedures cannot be called from function.
3. Procedures can have input/output parameters for it whereas functions can have only input parameters.
4. Procedure allows select as well as DML statement in it whereas function allows only select statement in it.
5. Exception can be handled by try-catch block in a procedure whereas try-catch block cannot be used in a function.
6. We can go for transaction management in procedure whereas we can't go in function.
7. Procedures can not be utilized in a select statement whereas function can be embedded in a select statement.

Best Related Posts are Following:

1. Comparison between MySQL and MongoDB.
2. What are differences between $(document).ready and $(window).load?.
3. Difference between MVC and MVP design pattern.
4. What is difference between event.preventDefault() and return false in Javascript?.
5. What is the difference between call and apply in javascript?.
6. Difference between inner join and outer join in MySQL.
7. Difference between theme and template in website.
8. Difference between in_array and array_key_exists in php with Example.
9. Difference between SSL and HTTPS.
10. Difference between Notice and warning and fatal error.
11. Difference between overloading and overriding in php with Example.
12. What is difference between natcasesort and sort?.
13. Difference Between Hadoop and Big-Data.
14. Difference Between Primary Key And Unique Key And Foreign Key And Composite Key.
15. PHP Sessions and Cookie and Security.
16. Difference between WebService and API.
17. Difference Between MyISAM and innoDB - MySQL.
18. Difference Between Zend framework 2 VS Zend framework 1.
19. Difference between JSON and JSONP.
20. Difference Between Cakephp and Zend Framework.
21. Difference between Abstract class and Interface in PHP.