Are PROCEDUREs preferable to FUNCTIONs in MySQL?

Question

If I have a logical task that has a single return value, is there any rule or guideline whether a FUNCTION or PROCEDURE should be used in MySQL? Are there specific use-cases where a FUNCTION is better than a PROCEDURE or vice versa?

I saw a related thread ( Stored procedures and functions ) but that is focused on SQL Server and I imagine this is quite an implementation-specific question; what is the answer for MySQL?

Read: http://stackoverflow.com/questions/3744209/mysql-stored-procedure-vs-function-which-would-i-use-when — eisberg, Nov 23 '12 at 09:44
I think that answers this - can I mark my own question to be closed/merged? — Mr. Boy, Nov 23 '12 at 14:40

score 1 · Answer 1 · answered Nov 23 '12 at 09:44

1

Functions/procedures return values, functions can be called inside another statement, procedures are statements, and cannot be called in another statement.

answered Nov 23 '12 at 09:44

damiankolasa

1,508
9
8

score 1 · Accepted Answer · edited May 23 '17 at 10:24

1

As John stated, my comment was already the answer.

Just read: MySQL stored procedure vs function, which would I use when?

edited May 23 '17 at 10:24

Community

1
1

answered Nov 23 '12 at 14:43

eisberg

3,731
2
27
38

Are PROCEDUREs preferable to FUNCTIONs in MySQL?

2 Answers2