View Issue Details

IDProjectCategoryView StatusLast Update
0002440SymmetricDSBugpublic2019-04-23 20:28
Reporterrotten Assigned To 
Prioritynormal 
Status newResolutionopen 
Product Version3.7.26 
Summary0002440: dbexport --sql doesn't work
DescriptionWhen I use dbexport --sql "select col_a, col_b from mytable" --format CSV, to dump a subset of the columns in my table, dbexport writes the names of all of the columns as the header, not just the ones from my select statement.

Then it picks columns off of the table in the order they are in the table, ignoring my select statement except to truncate the list at the number of columns I had in my select statement.

It appears to be completely ignoring my --sql statement except for the number of columns that it was returning.

** I've only tested dbexport --sql against mysql 5.6 at this time. **

Additional InformationMy work around is to use the mysql command line tool to generate the csv.
Tagsdbimport/dbexport

Activities

lonsiera

2015-11-11 16:15

reporter   ~0000729

You can use dbsql, it works

Issue History

Date Modified Username Field Change
2015-11-05 20:34 rotten New Issue
2015-11-11 16:15 lonsiera Note Added: 0000729
2019-04-23 20:28 elong Tag Attached: dbimport/dbexport