MySQL Commenting Gotcha

The — comment operator must be followed by a space. So if you have a comment like a header up top…like below


-- mysql engine v1.2
-- this is more commenttt
-------------------------
-- further comments below


This will cause an error on line 3. The second line has no space in it at all.  At least they have a reasonable error message for this, but it’s easily missed if you don’t read the error message.

Email Server Tip »« Turning a pile of spaghetti into a set of nearly orthogonal grids