Mysql – How to set the default table export format in MySQL workbench

Typically you build your schema in MySQL and you either let the app using the database populate itself with data over time, or you'll be importing existing data from an existing system using some level of scripting or programming, possibly/probably an extension of whatever system will be using the database.

I suppose certain test cases may exist where you'd want to use Workbench to generate some data; or maybe you want to populate some lookup tables at schema creation, but I'd think there would be better/easier ways...Regardless, MySQL's official documentation for this is here.

Add this to /etc/my.cnf (Linux) or my.ini (Windows)

[mysqld]
autocommit=0

Restart of mysql required !!! :(

UPDATE 2011-08-03 12:18 EDT

In MySQL Workbench you need to make sure the Data Changes Wizard is enabled. Here is why:

Enable Data Changes Commit Wizard - In the SQL Editor, when editing table data and then clicking the Applying changes to data button, a wizard is launched to step you through applying you changes. This gives you a chance to review the SQL that will be applied to the live server to make the requested changes. If the option is deselected, then the changes will simply be applied to the server, without the wizard being displayed, and without a chance to review the changes that will be made.

Here is how to check:

• Open MySQL Workbench
• Click Edit on Main Menu Bar
• Click Preferences Under Edit
• Click SQL Editor Tab
• Look for the Last CheckBox Under Query Results

If it is checked, data gets committed via a Wizard requiring user intervention.

If it is unchecked, data gets committed, bypassing MySQL's autocommit protocols.