What is difference between function and procedure in MySQL?
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. |
Also Read: RDBMS interview questions
BY Best Interview Question ON 09 Jan 2021