I define a simple stored function that works fine in my local test database, but when I try to create it on a "real" server, it just doesn't get added to the "proc" table. I do not get any errors or anything else, it just is not added (therefore, the function cannot be used, of course).
Both servers use the same version, and I see no difference between the structures of the "proc" tables.
Any ideas? Resolution Problem?
Thank.
EDIT: I tried to create a function in mysql-shell instead of phpMyAdmin, and this did the trick.
source
share