Bug #60498 Export with "extended insert" option does not wrap new line for each values row
Submitted: 16 Mar 2011 21:49 Modified: 17 Mar 2011 8:30
Reporter: Tiger O Email Updates:
Status: Verified Impact on me:
Category:MySQL Workbench: Administration Severity:S3 (Non-critical)
Version:5.2.33 CE OS:Microsoft Windows
Assigned to: CPU Architecture:Any
Tags: regression

[16 Mar 2011 21:49] Tiger O
the option "extended-insert" should dump a insert statement with multiple values in a "multi-row" format.  But it doesn't - all values rows are on a single line (paste this into a text editor to see):

INSERT INTO `my_table` (`column_1`,`column_2`,`column_3`) VALUES ('value_1','value_2','value_3'),('value_1','value_2','value_3'),('value_1','value_2','value_3');

How to repeat:
run an export with "multi-row" option turned on in "Advanced Export Options".

Suggested fix:
make each value set on its on line like so:

INSERT INTO `my_table` (`column_1`,`column_2`,`column_3`) VALUES

the indentation should be 1 space. It should look like this even if in NotePad with "Word Wrap" turned OFF.
[16 Mar 2011 21:50] Tiger O
This feature was in the old Query Browser but lost in WorkBench.
[17 Mar 2011 8:30] Valeriy Kravchuk
Yes, this is easy to verify, but looks like this is just --extended-insert option of mysqldump works (ans designed to work). It produces the most compact dump of data.

It is a valid feature request though to have an option to re-format the result in a way you described.
[2 May 2011 23:31] Tim Riker
See comments on Bug #4328 and other duplicates of that bug for more discussion.