Question: what is difference between stored procedure and function in mysql?
Answer: Stored procedure always returns an integer value of zero by default. Whereas function return types could be scalar or table or table values. ... A Function can be used in the SQL queries while a procedure cannot be used in SQL queries. That causes a major difference between function and procedures.