Knowledge base
1000 FAQs, 500 tutorials and explanatory videos. Here, there are only solutions!
Creating a MySQL function on a Cloud Server/Using DELIMITER
It is possible to create MySQL functions on a Cloud Server
For that to work, you will probably need to change the delimiters of your function during its definition. Without that, the CREATE FUNCTION will stop at the first semi-colon it encounters and return a syntax error (because the END of the function was not found).
Here is an example of the hello world function with its delimiters:
DELIMITER $$ /* We change the delimiter to add to $$ */CREATE FUNCTION hello_world()
RETURNS TEXT
LANGUAGE SQL
BEGIN
RETURN 'Hello World';
END;
$$ /* We finish the CREATE FUNCTION with our new delimiter */
DELIMITER ; /* We restore the old delimiter (the semi-colon) */
Link to this FAQ: