Re: Problem editing MySQL table due to foreign keys.

[Javier Treviño]

Hi GC,
Thanks for posting in our forums and for using our products!

Do you get that "Unrecognized GUID format" error if you try to just import the data from that table to an Excel spreadsheet?
Is that error thrown when trying to push the changes back to the server?

I can't know for sure without attempting to duplicate this issue with your database structure and data.

You can try to use MySQL Workbench, connect to your database and on the SQL Editor that opens up when double-clicking the connection you will be able to see the schemas at the left side on the Object Browser, find your table then right-click on it and select Edit Table Data. Please let us know if you run into the same error message.

If you successfully edit the data you want then I will proceed to raise a bug and probably ask you more information.

Thanks!

====================================
Javier Treviño
MySQL on Windows Team