Just a tip when using the output of CREATE CODE on functions in Heidi

I have a function in one of my databases (MariaDB) that creates a SHA256 hash of a user provided value combined with a salt.

I wanted to copy this to another database but the output of the CREATE CODE tab produced an error.

This occurs because the semicolons are being treated as query delimiters.

By adding

DELIMITER $$

before the CREATE CODE and

$$
DELIMITER ;

after it, the CREATE CODE works just fine.

The delimiter is temporarily set to $$ and then reverted to ;