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



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to