MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Richard Mixon (qwest) Date:July 27 2004 7:30pm
Subject:RE: How to show comments/annotations in MySQL client output
View as plain text  
Its not documented in my version 4.0.18 manual on Windows XP either. I
checked the Linux machine but cannot seem to find the "manual.html"
file.
The SYSTEM command DOES work in 4.0.18 on SuSE Linux, DOES NOT work on
4.0.18 under Windows.

 - Richard

> -----Original Message-----
> From: Markus Grossrieder [mailto:markus.grossrieder@stripped]
> Sent: Tuesday, July 27, 2004 9:49 AM
> To: Michael Stassen
> Cc: mysql@stripped
> Subject: Re: How to show comments/annotations in MySQL client output
>
>
> Michael,
>
> which version are you using ? I didn't find SYSTEM in the manual ...
>
> Thanks, Markus
>
> ----- Original Message -----
> From: "Michael Stassen" <Michael.Stassen@stripped>
> To: "Richard Mixon (qwest)" <rnmixon@stripped>
> Cc: <mysql@stripped>
> Sent: Tuesday, July 27, 2004 6:09 PM
> Subject: Re: How to show comments/annotations in MySQL client output
>
>
> >
> > One more thought: Your mention of echo jogged my memory.
> You can use SYSTEM
> > to pass what follows to the system and display the result.  So,
> >
> >    SYSTEM echo "## The following output should only contain
> two rows.";
> >
> > results in
> >
> >    ## The following output should only contain two rows.
> >
> > assuming echo is a command which makes sense to your system.
> >
> > Michael
> >
> >
> > Michael Stassen wrote:
> >
> > >
> > >
> > > Richard Mixon (qwest) wrote:
> > >
> > >> Harald Fuchs wrote:
> > >>
> > >>> In article <4105E556.5010305@stripped>,
> > >>> Michael Stassen <Michael.Stassen@stripped> 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
> > >
> > >
> > > Well, it's not exactly what you want, but you could use
> an alias to give
> > > each comment a standard header:
> > >
> > >   SELECT 'The following output should only contain two
> rows for status.'
> > >   AS COMMENT;
> > >
> > > +---------------------------------------------------------------+
> > > | COMMENT                                                       |
> > > +---------------------------------------------------------------+
> > > | The following output should only contain two rows for status. |
> > > +---------------------------------------------------------------+
> > > 1 row in set (0.00 sec)
> > >
> > > You still get some extra lines, but perhaps that looks a
> little better.
> > > You could also change the alias according to the type of comment:
> > >
> > >   SELECT 'The following output *must* contain only two rows!'
> > >   AS `WARNING!`;
> > >
> > > +----------------------------------------------------+
> > > | WARNING!                                           |
> > > +----------------------------------------------------+
> > > | The following output *must* contain only two rows! |
> > > +----------------------------------------------------+
> > > 1 row in set (0.00 sec)
> > >
> > > Michael
> > >
> > >
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1
> >
> >
>
> ----------------------------------------
> My Inbox is protected by SPAMfighter
> 1396 spam mails have been blocked so far.
> Download free www.spamfighter.com today!
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/mysql?unsub=1



Thread
How to show comments/annotations in MySQL client outputqwest)26 Jul
  • Re: How to show comments/annotations in MySQL client outputMichael Stassen27 Jul
  • Re: How to show comments/annotations in MySQL client outputHarald Fuchs27 Jul
    • RE: How to show comments/annotations in MySQL client outputqwest)27 Jul
      • RE: How to show comments/annotations in MySQL client outputPKeane27 Jul
        • RE: How to show comments/annotations in MySQL client outputqwest)27 Jul
      • Re: How to show comments/annotations in MySQL client outputMichael Stassen27 Jul
        • Re: How to show comments/annotations in MySQL client outputMichael Stassen27 Jul
          • RE: How to show comments/annotations in MySQL client outputqwest)27 Jul
            • Re: How to show comments/annotations in MySQL client outputMichael Stassen27 Jul
              • Re: How to show comments/annotations in MySQL client outputPaul DuBois28 Jul
                • Re: How to show comments/annotations in MySQL client outputMichael Stassen28 Jul
                  • RE: How to show comments/annotations in MySQL client outputqwest)28 Jul
      • Re: How to show comments/annotations in MySQL client outputMarkus Grossrieder27 Jul
        • RE: How to show comments/annotations in MySQL client outputqwest)27 Jul
Re: How to show comments/annotations in MySQL client outputMichael Stassen27 Jul