What is difference between function and procedure in MySQL?

Answer»

FUNCTION	Procedure
The function RETURNS the single value which is anyhow mandatory.	The procedure returns zero or N values.
They only work with a STATEMENT: Select	They can work with multiple statements: Insert, Update, Delete, Select.
In function, transactions are not possible	In the procedure, transactions are possible
Error handling is not possible	With try-catch, error handling is possible.

Discussion