In article <[EMAIL PROTECTED]>, Michael Stassen <[EMAIL PROTECTED]> writes:
> Richard Mixon (qwest) wrote: >> I run some mysql command files (just SQL statements in a file I read >> from standard input) and need to place some annotiations/comments in the >> output. >> If I place standard SQL comments ("-- comment text") or MySQL >> comments >> ("# comment text") they do not show up in the mysql client output. Well, >> in a way that makes sense - they are "comments". >> I have tried using "select ' comment text' ;" and that works, but I >> get >> many, many lines instead of my one simple annotation - e.g.: >> -------------- >> select "First comment ..." >> -------------- >> +-------------------+ >> | First comment ... | >> +-------------------+ >> | First comment ... | >> +-------------------+ >> 1 row in set (0.00 sec) >> Any/all ideas are appreciated - Richard >> > SELECT "First comment ..."; > will give exactly the output you show, but > SELECT "First comment ..." FROM sometable; > will return that string once for each row of the table. Is that what > you're doing? I guess he's talking about the column headers produced by the "mysql" client program. These can be suppressed by using "mysql -N". -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]