[thelist] mysql output formatting from shell
evolt at mccullough-net.com
evolt at mccullough-net.com
Fri Aug 20 10:38:46 CDT 2004
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.
More information about the thelist
mailing list