bug: insert/update screen; plus spelling mistake

[linarms]

On the 'Insert/Update Data' screen, when I try to update a table with a field named “Key” (which is part of the primary key), the update statement issued does not use “ to delimit the field name in the WHERE clause, so as “Key” is a MySQL keyword, SQLyog returns a MySQL error. If I happen to try this twice or attempt to close the insert/update screen without hitting “Cancel”, I also get an exception and have to kill SQLyog completely.

Could field names in the WHERE clause of UPDATE (and DELETE) statements issued by the insert/update screen please be delimited with “ as they are elsewhere in the same statement?

Also, just a whinge — in batch export files, the sql contains “Table struture for

“, rather than “Table struCture for ” 🙂

Thanks,

Luke

[Author]

Posts