Sample Header Ad - 728x90

MySQL Workbench Model sync sql_mode

0 votes
1 answer
1133 views
Using MySQL Work Bench, When I look at the system variables of a server I am connected to, it shows the SQL_MODE as "no engine substitution" When I open a Workbench Model, and use the "sync with any source" menu item. When it alters the tables, it runs the alter query using the follow sql_mode: SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'; Im not sure where it is getting that from, is it safe to override the sql_mode in the connection to be just no engine substitute? Why would it be trying to use a different mode when altering than the server shows it is using? The server itself is running 5.6.47
Asked by Lawrence Cooke (193 rep)
Apr 30, 2020, 10:42 AM
Last activity: Jun 3, 2025, 11:04 AM