Eric Yeh wrote:
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,
--skip-column-names or -N
-t, -vvv, etc, and nothing seems to work. Any suggestions, short of parsing my query itself for the headers?
Thanks,
Eric
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
