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]