Wednesday, 6 January 2016

MySQL Workbench Delimiter gotcha

I found a problem when working with MySQL Workbench and using a delimiter other than the standard semi colon.
The above 700 line SQL script appears to have run without error, only problem is that I have changed the delimiter to "$$" and forgotten to append that after the last statement in the script (create table). Looking closely at the result output you can see that the last statement executed was not the create table one.

So there's one thing to look out for, remember to put the last delimiter in.