Hi Richard,
not exactly sure what you want but try using \G at the end of the select
statements.
Also try using UNION.
e.g.
select "Put your comment here","" UNION select field1, field2 from table1
group by field 1 \G
You may get something that will work for you by messing with these
options combined with suppressing headers?
Peter Keane
Trocaire
Maynooth
Ireland
"Richard Mixon \(qwest\)" <[EMAIL PROTECTED]> wrote on 27/07/2004
15:36:45:
> Harald Fuchs wrote:
> > 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".
>
> Michael/Harald,
>
> Thanks for the tip. But:
>
> 1) Yes, I am just issuing: SELECT "First comment ...";
> and
> 2) The problem is that instead of getting a single line of text (i.e. my
> "annotation/comment"), I get many, for example the command "select
> "COMMENT 3";" produces the following (even using the -N flag when I
> startup mySQL):
> --------------
> SELECT "COMMENT 3"
> --------------
>
> +-----------+
> | COMMENT 3 |
> +-----------+
> 1 row in set (0.00 sec)
> The problem with "-N" is that is suppresses all of the headers. What I
> really need is an "echo" or "print" command.
>
> The idea is to guide the reader of the mysql client output with some
> comments. The SQL might look like the following:
> SELECT "The following output should only contain two rows for status
> ...";
> SELECT status,count(*) FROM PoClass GROUP BY status;
> SELECT "The following output should only contain three rows for status
> ...";
> SELECT status,count(*) FROM PoClassMeasurement GROUP BY status;
>
> Thank you - Richard
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
>
