NAME¶

mysql-xml-to-csv — Convert MySQL XML output to CSV

SYNOPSIS¶

DESCRIPTION¶

mysql-xml-to-csv converts MySQL XML query results (i.e., produced using the mysql(1) command when given the --xml flag) into a CSV file.

The XML input is read from input.xml, if specified, otherwise standard input. The CSV output is written to standard output.

The first row of the CSV output contains column names unless the -N flag is given.

If the query result set contains zero rows, then by default nothing is output; this behavior can be altered using the -E flag.

By default NULL column values are converted into the empty string; this behavior can be altered using the -n flag.

The character encoding used for the CVS output is UTF-8.

OPTIONS¶

-E

If the result set contains zero rows, output line followed by a newline character instead of outputting nothing. No validation of line is performed.

-n

Output value instead of the empty string for NULL values.

-N

Do not output the column names in the first row of the output file.

-s

Specify an alternate column separator (default is comma).

RETURN VALUES¶

mysql-xml-to-csv exits with one of the following values:

0

Input was successfully processed.

1

An error occurred.

SEE ALSO¶

mysql-xml-to-csv: Convert MySQL XML output to CSV, https://github.com/archiecobbs/mysql-xml-to-csv.

AUTHOR¶

Archie L. Cobbs ⟨archie.cobbs@gmail.com⟩