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
