use a smaller font. This is really a function of your shell or client, not MySQL.
humbly, =C= * Cal Evans * http://www.christianperformer.com * Stay plugged into your audience * The measure of a programmer is not the number of lines of code he writes but the number of lines he does not have to write. * ----- Original Message ----- From: "Asif Iqbal" <[EMAIL PROTECTED]> To: "Paul DuBois" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, June 03, 2003 10:57 AM Subject: Re: mysql query output get wrapped > > 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] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
