When I try using the --xml or --html option with a batch file using INTO
OUTFILE 'dirpath', the --xml or --html option seems to be ignored in
favor of the tab-delimited default. (If I get rid of the INTO OUTFILE,
xml or html displays fine in the terminal.)
I tried using the pager to write to a file from inside MySQL. I
succeeded, but it was table data. I couldn't figure out how to add the
--xml or --html options from inside the pager.
I tried the redirection operator from the command line, but I haven't
stumbled on the correct syntax if such a syntax does exist.
Does anyone know how to write an --xml or --html file from a SELECT
statement, either from the command line or from a batch file? This would
really be useful information.
Thanks in advance for reading or responding.