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:
> >> >Except I want it HorizontallyAt 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) >> >> >> >Asif>> >> 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 >> >
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
