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
