Did not work prompt > echo "select * from Tickets limit 1;" | mysql mydb > res prompt > cat res
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 Still wrapped :-) On Tue, 3 Jun 2003, Thomas Spahni wrote: > Asif, > > try this: > > prompt> echo "select * from Tickets limit 1;" | mysql mydb > result.file > > You get everything in ONE line. > > Cheers, > Thomas > > On Tue, 3 Jun 2003, 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 > > > > 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]
