Michael Stassen wrote:
> Paul DuBois wrote:
>
>> At 15:57 -0400 7/27/04, Michael Stassen wrote:
>>
>>> First, I should point out that I've never used mysql on Windows.
>>>
>>> The manual makes no mention that I can see of system not being
>>> supported on the Windows mysql client. On the other
Paul DuBois wrote:
At 15:57 -0400 7/27/04, Michael Stassen wrote:
First, I should point out that I've never used mysql on Windows.
The manual makes no mention that I can see of system not being
supported on the Windows mysql client. On the other hand, Windows is
so different that I
http://dev.my
At 15:57 -0400 7/27/04, Michael Stassen wrote:
First, I should point out that I've never used mysql on Windows.
The manual makes no mention that I can see of system not being
supported on the Windows mysql client. On the other hand, Windows
is so different that I
http://dev.mysql.com/doc/mysql/e
First, I should point out that I've never used mysql on Windows.
The manual makes no mention that I can see of system not being supported on
the Windows mysql client. On the other hand, Windows is so different that I
wouldn't be surprised if system is not supported. A simple test would be to
s
gt; From: Markus Grossrieder [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, July 27, 2004 9:49 AM
> To: Michael Stassen
> Cc: [EMAIL PROTECTED]
> Subject: Re: How to show comments/annotations in MySQL client output
>
>
> Michael,
>
> which version are you using ? I didn't
[EMAIL PROTECTED] wrote:
> 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
, 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
Michael,
Great idea, I can get it to work on SuSE Linux (SLES8 for AMD64) just
fine:
mysql> SYSTEM echo "Some comments" ;
Some comments
But on Windows XP (where my user is running that needs this function):
mysql> SYSTEM echo Some comments ;
--
SYSTEM echo Some comments
--
ersion are you using ? I didn't find SYSTEM in the manual ...
Thanks, Markus
- Original Message -
From: "Michael Stassen" <[EMAIL PROTECTED]>
To: "Richard Mixon (qwest)" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, July 27, 2004 6:
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
Richard Mixon (qwest) wrote:
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
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
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. I
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 comm
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 mys
15 matches
Mail list logo
