I’m looking at MySQL stored procedures and functions. What is the real difference?
They seem to be similar, but a function has more limitations.
I’m likely wrong, but it seems a stored procedure can do everything and more than a stored function can. Why/when would I use a procedure vs a function?