Hello,
I am a new user of MySQL and have a simple question I was hoping the list could
help me with.
I have been a long time Sybase user and am now looking at converting some of my
scripts to MySQL. I ordinarily run scripts as batch from the command line, and
parse the results in a proprietary language. My parsers recognize csv-style
files (first row as a header, everything delimited by some character), which
generally works well with the MySQL batch output. However, I have observed the
exceedingly strange functionality that when the result of a query is empty,
MySQL returns nothing, instead of just the header with no data. This is
mathematicaly inconsistent behavior, and of course breaks my scripts. Since it
is unexpected behavior, though, I expect MySQL should have an easy option or
some such to get around this. I have tried --column-names, -t, -vvv, etc, and
nothing seems to work. Any suggestions, short of parsing my query itself for
the headers?
Thanks,
Eric
Eric Yeh
Vice President
MB Volatility Arbitrage
Deutsche Bank
280 Park Avenue
New York, NY 10017
212-454-6578
--
This e-mail may contain confidential and/or privileged information. If you are
not the intended recipient (or have received this e-mail in error) please
notify the sender immediately and destroy this e-mail. Any unauthorized
copying, disclosure or distribution of the material in this e-mail is strictly
forbidden.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]