| 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: | Windows |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | regression | ||
[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.
Description: 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 ('value_1','value_2','value_3'), ('value_1','value_2','value_3'), ('value_1','value_2','value_3'); the indentation should be 1 space. It should look like this even if in NotePad with "Word Wrap" turned OFF.