What is difference between function and procedure in MySQL?
|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
Suggest An Answer
No suggestions Available!