[thelist] mysql output formatting from shell

[evolt at mccullough-net.com]

Normally output looks something like this:

+---------------------+----------+
| email               | password |
+---------------------+----------+
| someemail at email.com | blahbla  |
+---------------------+----------+


Where I want:

someemail at email.com|blahbla
anotheremail at email.com|notblah

or output where its

**** 1 ****
someemail at email.com
blahbla
**** 2 ****
anotheremail at email.com
notblah



Quoting Chris Johnston <fuzzylizard at gmail.com>:

> On Fri, 20 Aug 2004 09:23:39 -0500, evolt at mccullough-net.com
> <evolt at mccullough-net.com> wrote:
> > Looking for some help on formatting the output you get from running a
> statement
> > on the command line interface for mysql.  I dont need the header or the
> boxes
> > and would like to have it print each row per line or pipe delimit the
> output.
> > 
> 
> What are wanting the output for and what are you using the process it
> with? I have done something similar with DB2, but I had to use shell
> script to parse and tidy up the output.
> 
> 
> -- 
> chris johnston
> 
> www.fuzzylizard.com
> 
> "For millions of years, mankind lived just like the animals and
> something happened which unleashed the power of our imagination, we
> learned to talk."
> Pink Floyd
> -- 
> 
> News! - Evolt.org conference for web professionals. 
> 17-19 September 2004 in Toronto, Canada. 
> Details at http://TOevolt.org
> 
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
> 
> For unsubscribe and other options, including the Tip Harvester 
> and archives of thelist go to: http://lists.evolt.org 
> Workers of the Web, evolt ! 
> 




----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.