List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:June 3 2003 4:14pm
Subject:Re: mysql query output get wrapped
View as plain text  
At 11:57 -0400 6/3/03, Asif Iqbal wrote:
>something like this
>
>+----+-------------+-------+--------+----------------+------------+-------+---------------+-----------------+
>| id | EffectiveId | Queue | Type   | IssueStatement | Resolution | Owner
>| Subject       | InitialPriority |
>+----+-------------+-------+--------+----------------+------------+-------+---------------+-----------------+
>|  5 |           5 |     4 | ticket |           NULL |       NULL |    16
>| RE: phonebook |              10 |
>+----+-------------+-------+--------+----------------+------------+-------+---------------+-----------------+
>
>*unwrapped*

That stilll looks wrapped to me.

Anyway, no, there is no option for doing that.  You'd need to perform
this kind of formatting yourself.

>
>
>On Tue, 3 Jun 2003, Paul DuBois wrote:
>
>>  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 wrote:
>>  >>  >mysql> select * from Tickets limit 1;
>>  >> 
>>>+----+-------------+-------+--------+----------------+------------+-------+---------------+-----------------+---------------+----------+----------+------------+----------+---------------------+--------+---------+---------------------+----------+---------------+---------------------+---------+---------------------+----------+
>>  >>  >| id | EffectiveId | Queue | Type   | IssueStatement | 
>>Resolution | Owner
>>  >>  >| Subject       | InitialPriority | FinalPriority | Priority 
>>| Status   |
>>  >>  >TimeWorked | TimeLeft | Told                | Starts | Started |
> Due
>>  >>  >| Resolved | LastUpdatedBy | LastUpdated         | Creator |
> Created
>>  >>  >| Disabled |
>>  >> 
>>>+----+-------------+-------+--------+----------------+------------+-------+---------------+-----------------+---------------+----------+----------+------------+----------+---------------------+--------+---------+---------------------+----------+---------------+---------------------+---------+---------------------+----------+
>>  >>  >|  5 |           5 |     4 | ticket |           NULL | 
>>NULL |    16
>>  >>  >| RE: phonebook |              10 |            80 |       10 
>>| resolved |
>>  >>  >0 |     NULL | 1970-01-01 00:00:00 | NULL   | NULL    |
> 1970-01-01
>>  >>  >00:00:00 | NULL     |             1 | 2001-04-17 18:38:02 |      
> 1 |
>>  >>  >2001-04-17 18:26:46 |        0 |
>>  >> 
>>>+----+-------------+-------+--------+----------------+------------+-------+---------------+-----------------+---------------+----------+----------+------------+----------+---------------------+--------+---------+---------------------+----------+---------------+---------------------+---------+---------------------+----------+
>>  >>  >1 row in set (0.00 sec)
>>  >>  >
>>  >>  >Is there a way I can get the output unwrapped
>>  >>  >
>>  >>  >something like this
>>  >>  >
>>  >>  >mysql> select * from Tickets limit 1 \G
>>  >>  >*************************** 1. row ***************************
>>  >>  >              id: 5
>>  >>  >     EffectiveId: 5
>>  >>  >           Queue: 4
>>  >>  >            Type: ticket
>>  >>  >  IssueStatement: NULL
>>  >>  >      Resolution: NULL
>>  >>  >           Owner: 16
>>  >>  >         Subject: RE: phonebook
>>  >>  >InitialPriority: 10
>>  >>  >   FinalPriority: 80
>>  >>  >        Priority: 10
>>  >>  >          Status: resolved
>>  >>  >      TimeWorked: 0
>>  >>  >        TimeLeft: NULL
>>  >>  >            Told: 1970-01-01 00:00:00
>>  >>  >          Starts: NULL
>>  >>  >         Started: NULL
>>  >>  >             Due: 1970-01-01 00:00:00
>>  >>  >        Resolved: NULL
>>  >>  >   LastUpdatedBy: 1
>>  >>  >     LastUpdated: 2001-04-17 18:38:02
>>  >>  >         Creator: 1
>>  >>  >         Created: 2001-04-17 18:26:46
>>  >>  >        Disabled: 0
>>  >>  >1 row in set (0.00 sec)
>>  >>  >
>  > >>  >Except I want it Horizontally
>>  >>
>>  >>  What would that look like?  I'm having trouble understanding how your
>>  >>  request isn't self-contradictory (it seems you want vertical output,
> but
>>  >>  horizontal?).
>>  >>
>>  >>  >
>>  >>  >Thanks
>>  >>  >
>  > >>  >Asif

Thread
mysql query output get wrappedAsif Iqbal3 Jun
  • Re: mysql query output get wrappedPaul DuBois3 Jun
    • Re: mysql query output get wrappedAsif Iqbal3 Jun
      • Re: mysql query output get wrappedPaul DuBois3 Jun
        • Re: mysql query output get wrappedAsif Iqbal3 Jun
          • Re: mysql query output get wrappedCal Evans3 Jun
            • Re: mysql query output get wrappedAsif Iqbal3 Jun
          • Re: mysql query output get wrappedPaul DuBois3 Jun
          • Re: mysql query output get wrappedDon Read4 Jun
  • Re: mysql query output get wrappedThomas Spahni3 Jun
    • Re: mysql query output get wrappedAsif Iqbal3 Jun
      • Re: mysql query output get wrappedJoel Rees4 Jun
  • Re: mysql query output get wrappedChris Tucker3 Jun
    • Re: mysql query output get wrappedAsif Iqbal3 Jun
      • Re: mysql query output get wrappedChris Tucker3 Jun
        • Re: mysql query output get wrappedAsif Iqbal3 Jun
          • Re: mysql query output get wrappedChris Tucker3 Jun
RE: mysql query output get wrappedSanjeev Sagar3 Jun
  • RE: mysql query output get wrappedAsif Iqbal3 Jun
RE: mysql query output get wrappedKeith Stevenson3 Jun
RE: mysql query output get wrappedBarry.Dancis3 Jun
RE: mysql query output get wrappedDave Christensen3 Jun