I did that before with a switch , just forgot On Tue, 3 Jun 2003, Cal Evans wrote:
> 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] > > > > > > -- 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]
