Comments - Two days in, and I still can't find the cause of this 1064 error.
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.
Thanks for checking this and for responding.
I'm using the HeidiSQL 126.96.36.19984 that came as part of the MariaDB 10.0.28 download.
I have not used the comand line, and would sooner do what I need to with a non-procedure succession of stand-alone queries (and some intermediary tables) in HeidiSQL (or some comparable client) than use the command line. In my limited DB experience, I've used only Oracle SQL Developer and TOAD for Oracle. Do you have any recommendations for free or low-cost HeidiSQL alternatives for MariaDB? I'll google about that, but value first-person recommendations.
You can take a look at some alternatives at Graphical and Enhanced Clients. If this is a HeidiSQL issue, please report it as a bug - it seems a strangely trivial issue, so perhaps there's something else being missed that others can pick up when they try recreate it.