List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:June 3 2003 3:52pm
Subject:Re: mysql query output get wrapped
View as plain text  
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
>>  >
>>
>>
>
>--
>Asif Iqbal
>http://pgpkeys.mit.edu:11371/pks/lookup?op=get&search=0x8B686E08
>There's no place like 127.0.0.1
>
>
>--
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe:    http://lists.mysql.com/mysql?unsub=1

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