Bug #73956 Database table export function to CSV
Submitted: 17 Sep 2014 20:38 Modified: 24 Sep 2014 15:13
Reporter: Jeff Walton Email Updates:
Status: Closed Impact on me:
Category:MySQL Workbench Severity:S1 (Critical)
Version:MySQL Workbench CE for Windows version 5 OS:Windows (Windows 7 professional)
Assigned to: CPU Architecture:Any

[17 Sep 2014 20:38] Jeff Walton
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.