something like this +----+-------------+-------+--------+----------------+------------+-------+---------------+-----------------+ | id | EffectiveId | Queue | Type | IssueStatement | Resolution | Owner | Subject | InitialPriority | +----+-------------+-------+--------+----------------+------------+-------+---------------+-----------------+ | 5 | 5 | 4 | ticket | NULL | NULL | 16 | RE: phonebook | 10 | +----+-------------+-------+--------+----------------+------------+-------+---------------+-----------------+
*unwrapped* 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 > >> > > >> > >> > > > >-- > >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/[EMAIL PROTECTED] > > -- 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/[EMAIL PROTECTED]