Bug #79823 Updating tables

• Submitted: 2 Jan 2016 10:02
• Modified: 28 Oct 2016 13:48
• Reporter: Matthew van der Toorn Vrijthoff
• Status: Not a Bug
• Category: MySQL Workbench
• Severity: S3 (Non-critical)
• Version: 6.3.5
• OS: MacOS (10.11.2)
• CPU Architecture: Any
• Tags: Update tables

[2 Jan 2016 10:02] Matthew van der Toorn Vrijthoff

Description:
When you apply changes to a table with MySQL workbench and the create some new changes the old query's are in the SQL query. Due to this issue the second table update query always fails. This is very annoying because you have to close the tab or edit the query manually.

How to repeat:
Update table column names and/or datatypes. Then update those records without closing the tab.

Suggested fix:
Remove the previous query's that are already applied to the database. When you do it manually it works fine.

[28 Oct 2016 13:48] MySQL Verification Team

Thank you for the bug report. The query editor was designed in that way so if you have several statement lines you could can run only the selected queries do you want, that is explained in the Manual:

https://dev.mysql.com/doc/workbench/en/wb-sql-editor-main-menu.html