Hi Scott -H outputs the file nicely as a HTML bordered table, but I was more looking for a way to output the file as a "bordered" ASCII table (like a screen print below) any clues? cheers Mark Dale -----Previous Message----- >Have you tried the -H switch to output as HTML? > >see mysql -help > > - Scott > > > -----Original Message----- > > > Could anybody tell me if there a variation of this string to output a >> file in table format that looks like the one below. >> >> mysql -N -e "select query here" db_name > output_file >> >> >> +---------------------+-------+-------+-------------------------+ >> | datetime | jobno | hours | description | >> +---------------------+-------+-------+-------------------------+ >> | 2001-01-08 08:13:02 | FX395 | 1.00 | Fotel | >> | 2001-01-08 08:19:54 | HSE | 1.00 | Administration | >> | 2001-01-08 09:58:05 | FX405 | 0.50 | New Brand | >> | 2001-01-08 10:06:46 | WC362 | 1.00 | Check proofs | >> | 2001-01-08 11:52:40 | MB021 | 1.00 | Medi Experience | >> | 2001-01-08 11:53:49 | FX405 | 3.00 | New Brand book | >> | 2001-01-08 11:55:22 | HSE | 0.50 | Administration | >> | 2001-01-08 12:36:51 | WC373 | 0.50 | Personal Loan Letter | >> | 2001-01-08 16:42:25 | WR450 | 0.25 | DL Flyer - check art | >> | 2001-01-08 17:01:35 | TF009 | 0.25 | Australia | >> | 2001-01-10 10:46:37 | MB001 | 8.00 | General Strategy. | >> | 2001-01-10 10:48:22 | HSE | 0.75 | Meeting with Tony. | >> | 2001-01-10 10:49:27 | MB021 | 0.50 | Medi Experience | >> | 2001-01-10 10:50:25 | FX405 | 0.50 | Brand Book | >> +---------------------+-------+-------+-------------------------+ >> >> >> For anyone who missed it the other day, Paul DuBois posted this to >> output a comma-delimited file. Works great! >> >> mysql -N -e "your query here" db_name | tr '\t' , > output_file >> >> >> cheers >> >> Mark Dale > > -- -- --------------------------------------------------------------------- Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to: <[EMAIL PROTECTED]> If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php
