Re: xpost from triggers: create before insert, mysqlworkbench: the object's DDL contains syntax error

[Kenneth Christensen]

Thanks very much.That compiles cleanly now.

I'm just starting out in the MySQL universe, my background is ~25 years as an Oracle Consultant. Still, it's been 8 years since I've retired and I'm learning that a lot that I thought I knew I have to relearn.

Anyway, if you've time, why don't we need a ";" after the SELECT statement, in addition to the one that closes the SET? (Just starting to learn about SET.)

Thanks for your help.