Return to Answer

don't expand backslashes, and keep leading and trailing whitespace (not a problem here but a good habit to get into)

Source Link

edited Feb 9, 2012 at 0:22

866.6k
205
1.8k
2.3k

mysql --format csv --skip-column-names \
    -e "select xmldata from mytable limit 1;" \
    | while IFS= read -r line; do xmllint --format - <<<$line;<<<"$line"; done

Split for easier reading, obviously you don't need to. The <<<$line is a herestring, which feeds the contents of $line to xmllint as stdin.

mysql --format csv --skip-column-names \
    -e "select xmldata from mytable limit 1;" \
    | while read line; do xmllint --format - <<<$line; done

Split for easier reading, obviously you don't need to. The <<<$line is a herestring, which feeds the contents of $line to xmllint as stdin.

mysql --format csv --skip-column-names \
    -e "select xmldata from mytable limit 1;" \
    | while IFS= read -r line; do xmllint --format - <<<"$line"; done

Split for easier reading, obviously you don't need to. The <<<$line is a herestring, which feeds the contents of $line to xmllint as stdin.

Source Link

answered Feb 8, 2012 at 22:05

Kevin

41.8k
17
91
113

mysql --format csv --skip-column-names \
    -e "select xmldata from mytable limit 1;" \
    | while read line; do xmllint --format - <<<$line; done

Split for easier reading, obviously you don't need to. The <<<$line is a herestring, which feeds the contents of $line to xmllint as stdin.