Bug #73956 Database table export function to CSV

• Submitted: 17 Sep 2014 20:38
• Modified: 24 Sep 2014 15:13
• Reporter: Jeff Walton
• Status: Closed
• Category: MySQL Workbench
• Severity: S1 (Critical)
• Version: MySQL Workbench CE for Windows version 5
• OS: Windows (Windows 7 professional)
• CPU Architecture: Any

[17 Sep 2014 20:38] Jeff Walton

Description:
If the last column of a table is a VARCHAR and you attempt to make an export, the last column does not have double quotes wrapped around the string.  This means if you attempted to do a mass insert to a table with that script, it would fail.  Therefore you would have to manually correct the data or concatenate the quotes on the last column.

How to repeat:
query all or selected columns from a table where the last column in the select list is a VARCHAR(255) or any size.  Then export the output using the export icon showing excel to a CSV file.  Look at the file using notepad++ and NOT Excel.  Notice the double quotes are missing from the last string on every exported record.

[17 Sep 2014 23:46] MySQL Verification Team

Please try Development Release 6.2.2 rc version. Thanks.

[23 Sep 2014 20:51] MySQL Verification Team

Thank you for the feedback. Please try the GA release version 6.2.3 and comment if that issue continues. Thanks.

[24 Sep 2014 14:23] MySQL Verification Team

If the missing dll file continues. Please install the MSVC 2013 runtime redistributables from MS: http://www.microsoft.com/en-us/download/details.aspx?id=40784. Thanks.

[24 Sep 2014 15:13] MySQL Verification Team

Thank you for the feedback.