Forums | Webyog
Tools to manage and monitor MySQL databases
forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Bug on data update
The answer is not to use mysql keywords as database, table or field names.
This is not a bug in SQLYog.
=C=
This issue has already been fixed in our 3.8 development tree. From 3.8, SQLyog will put backticks around all object names.
Still it is advised that you dont use MySQL keywords as db,table, index etc. names 🙂
Brilliant, thank you. I agree with Cal that keywords shouldn't be used, but, when you have no choice (ie, the database schema is not in your control), what's a guy supposed to do?
Cheers,
Andy Chapman.