Skip navigation links
5.4.7 The Diagram Tab »
Section Navigation      [Toggle]

5.4.6. The Model:MySQL Tab

This enables you to set the default table storage engine, MySQL Server version, and SQL_MODE to be used for generated scripts.

Figure 5.7. The Model:MySQL Preferences

The Model:MySQL preferences

  • Default Target MySQL Version: Certain features will utilize options for this MySQL Version.

    This option was added in MySQL Workbench 5.2.45.

  • Default Storage Engine: Tables created in MySQL Workbench will be defined using this default storage engine.

  • SQL_MODE to be used in generated scripts: Defaults to "TRADITIONAL,ALLOW_INVALID_DATES", this defines the SQL_MODE used by Forward Engineering and Synchronization.

Copyright © 2006, 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices