MySQL DELIMITER syntax errors

Try

DELIMITER ;

not

DELIMITER;

You're actually specifying ; as an argument to the DELIMITER command, so not having the space there may be confusing it.

sql mysql triggers delimiter

You need a space between 'DELIMITER' and ';'

DELIMITER ;# not:DELIMITER;

sql mysql triggers delimiter

Just as an add-on, for someone else:

The delimiter is required to enable the entire definition to be passed to the server as a single statement.

CodeHunter