Sample Header Ad - 728x90

MySQL Workbench Synchronization False Positives

0 votes
1 answer
174 views
I have synchronized a table between a model and a live server database in Workbench, but every time I rerun the "Synchronize With Any Source..." wizard, Workbench detects (falsely) that there is a difference between the model and the server for that table and wants to execute the exact same SQL query. The SQL in this case is the following: ALTER TABLE mydb.user_info CHANGE COLUMN last_update last_update DATETIME NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP This statement has already been executed in my first run of the Wizard, and I can see that the table user_info is up to date on the live server. Why does it keep detecting it as a difference? Is it a known bug with MySQL Workbench or something...?
Asked by Neo_999 (1 rep)
Jul 10, 2016, 09:29 PM
Last activity: Jul 2, 2025, 12:03 PM