trigger (delimiter)

[Adrian Benko]

I have a problem with creating trigger. Command "delimiter |" doesn't
work alone nor together with CREATE TRIGGER command. Is it possible to
create triggers (procedures) in sql cloud?

delimiter |

CREATE TRIGGER trigger_name AFTER INSERT ON tablex
FOR EACH ROW BEGIN
.......
END;
|

delimiter ;

[Giovanni Mascia]

Yes it is, but entering these kind of commands through the browser-based input box may not be the best option.

I had more luck trying to create triggers and procedures (and changing the delimiter) through the command line tool or the Squirrel SQL client.

[Johannes Braunias]

Hi, how could you enter a DELIMITER // command in the command line tool?
It doesn't accept mine ...

[Rob Clevenger]

Just following up on this, The command line tool download was updated to fix this recently.

Rob

[Johannes Braunias]

Great!