Re: How to show comments/annotations in MySQL client output

[Michael Stassen]

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?

Michael