Forums | Webyog
Tools to manage and monitor MySQL databases
forums › forums › SQLyog › Using SQLyog › Error when updating table
Can you send us your table structure and a sample data so that we can work on the problem at our side. You can generate SQL scripts for your database by using SQLyog's DB->Export Database As Batch Scripts…. option.
I eventually solved this problem myself: in MySQL there are reserved words that can't be used as column names and so forth. See:
http://www.mysql.com/doc/en/Reserved_words.html
I used a name for my key field which worked ok in MS Access 97 but not in SQLyog + MySQL. Not the fault of the SQLyog program.
Be warned.