On 03-Jun-2003 Asif Iqbal wrote:
>
> something like this
>
> ++-+---++++---
> +---+-+
>| id | EffectiveId | Queue | Type | IssueStatement | Resolution | Owner
>| Subject | InitialPriority |
> ++--
> Did not work
I wonder ...
> prompt > echo "select * from Tickets limit 1;" | mysql mydb > res
> prompt > cat res
>
> id EffectiveId Queue TypeIssueStatement Resolution
> Owner Subject InitialPriority FinalPriority PriorityStatus
> TimeWorked TimeLeftTol
QL Manager, etc, I think this might be your
best bet.
-Original Message-
From: Keith Stevenson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 03, 2003 11:14 AM
To: 'Asif Iqbal'; Paul DuBois
Cc: [EMAIL PROTECTED]
Subject: RE: mysql query output get wrapped
Asif,
If I underst
Are you using the -S switch to less? Note that it's a capital S, not lower
case. Does the output get properly sent through the less pager (i.e do you have
to page through the results that get selected)? Check the manpage for less on
your machine and find out what the truncate lines option is,
I am on solaris 2.8 sparc. You less works fine if I use \G switch. But I
want (as you explained) list of column names in one line in first row and
the results are thereafter in single rows instead of getting wrapped.
Like I said wish I remebered the swithc for that
On Tue, 3 Jun 2003, Chris Tuck
What platform are you on? If you're on windows you probably won't have less
installed, in which case you'll need to either (a) install it or (b) use a
different pager (not sure what you'll have with windows, you'd have to
independently research it). I'm assuming that what you want is to have t
That works with \G switch , but without the \G switch Istill get it
wrapped
wish I can remeber the switch
On Tue, 3 Jun 2003, Chris Tucker wrote:
> The pager option can be used to accomplish this (if you don't mind having things
> running through, e.g., less). When I need to do this I just do:
The pager option can be used to accomplish this (if you don't mind having things
running through, e.g., less). When I need to do this I just do:
mysql> \P less -S
mysql>
You'll get unwrapped output (the -S option to less tells it to truncate rather
than wrap over-long lines).
You can use anyt
ow if mysql has similar features. I didn't find them in the manual.
Barry
-Original Message-
From: Asif Iqbal [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 03, 2003 12:10 PM
To: Thomas Spahni
Cc: [EMAIL PROTECTED]
Subject: Re: mysql query output get wrapped
Did not work
prompt &
this Helps
Kind Regards
-Original Message-
From: Asif Iqbal [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 03, 2003 4:57 PM
To: Paul DuBois
Cc: [EMAIL PROTECTED]
Subject: Re: mysql query output get wrapped
something like this
At 11:57 -0400 6/3/03, Asif Iqbal wrote:
something like this
++-+---++++---+---+-+
| id | EffectiveId | Queue | Type | IssueStatement | Resolution | Owner
| Subject | InitialPriority |
++---
TECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Tuesday, June 03, 2003 10:57 AM
> Subject: Re: mysql query output get wrapped
>
>
> >
> > something like this
> >
> >
> ++-+---++++---+-
&g
Did not work
prompt > echo "select * from Tickets limit 1;" | mysql mydb > res
prompt > cat res
id EffectiveId Queue TypeIssueStatement Resolution
Owner Subject InitialPriority FinalPriority PriorityStatus
TimeWorked TimeLeftToldStarts Started Due
write.
*
- Original Message -
From: "Asif Iqbal" <[EMAIL PROTECTED]>
To: "Paul DuBois" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, June 03, 2003 10:57 AM
Subject: Re: mysql query output
Asif,
try this:
prompt> echo "select * from Tickets limit 1;" | mysql mydb > result.file
You get everything in ONE line.
Cheers,
Thomas
On Tue, 3 Jun 2003, Asif Iqbal wrote:
>
> mysql> select * from Tickets limit 1;
> ++-+---++++---+
something like this
++-+---++++---+---+-+
| id | EffectiveId | Queue | Type | IssueStatement | Resolution | Owner
| Subject | InitialPriority |
++-+---+++---
At 11:39 -0400 6/3/03, Asif Iqbal wrote:
I want the columns unwrapped to make it easy to read. Sorry if I confused
you earlier
I still don't know what you mean. What would this output *look like*?
Please show an example.
On Tue, 3 Jun 2003, Paul DuBois wrote:
At 11:27 -0400 6/3/03, Asif Iqbal
-
> From: Asif Iqbal [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, June 03, 2003 10:27 AM
> To: [EMAIL PR
I want the columns unwrapped to make it easy to read. Sorry if I confused
you earlier
On Tue, 3 Jun 2003, Paul DuBois wrote:
> At 11:27 -0400 6/3/03, Asif Iqbal wrote:
> >mysql> select * from Tickets limit 1;
> >++-+---++++---+
-
From: Asif Iqbal [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 03, 2003 10:27 AM
To: [EMAIL PROTECTED]
Subject: mysql query output g
At 11:27 -0400 6/3/03, Asif Iqbal wrote:
mysql> select * from Tickets limit 1;
++-+---++++---+---+-+---+--+--++--+-++-+
mysql> select * from Tickets limit 1;
++-+---++++---+---+-+---+--+--++--+-++-+-+--+---
22 matches
Mail list logo
