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
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
