mysql> select * from Tickets limit 1 \g +----+-------------+-------+--------+----------------+------------+-------+---------------+-----------------+---------------+----------+----------+------------+----------+---------------------+--------+---------+---------------------+----------+---------------+---------------------+---------+---------------------+----------+ | 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.01 sec)
That did not help . I not \G is not the one On Tue, 3 Jun 2003, Sagar, Sanjeev wrote: > Try -E option or put "\g" in end of your sql statement like below > > Mysql -u <id> -p<passwd> -E -e "show innodb status" > > OR > > Mysql -u <id> -p<passwd> -e "show innodb status \g" > > I am not sure it is little "g" or capital "G". Try both way. > > -----Original Message----- > From: Asif Iqbal [mailto:[EMAIL PROTECTED] > Sent: Tuesday, June 03, 2003 10:27 AM > To: [EMAIL PROTECTED] > Subject: mysql query output get wrapped > > > > 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 > > 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]
