MYSQL-XML-TO-CSV(1)

🌸 NAME 🌸

Okay bestie, welcome to the mysql-xml-to-csv(1) page from the General Commands Manual — it's literally the glow-up guide for mysql-xml-to-csv — Convert MySQL XML output to CSV. XML in, CSV out, no cap. 💅

✨ SYNOPSIS ✨

mysql-xml-to-csv [-E line] [-n value] [-N] [-s separator] [input.xml]

💖 DESCRIPTION 💖

So here's the vibe: mysql-xml-to-csv converts MySQL XML query results — like, the ones produced using the mysql(1) command when given the --xml flag — into a CSV file. Iconic behavior, honestly.

The XML input is read from input.xml if it's specified; otherwise it comes from standard input. The CSV output gets written to standard output. Very main-character energy: reads quietly, writes to stdout. 🦋

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. Yes bestie, zero rows means zero drama by default. 💀

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>

---

That's the whole manual, bestie. This page is from Debian and dated September 16, 2024 — slay. 💅✨