List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:June 3 2003 3:36pm
Subject:Re: mysql query output get wrapped
View as plain text  
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