Re: How to print in MySQL ?

[Andrew Gould <andrewgould@xxxxxxxxx>]

I don't know how to print from within mysql; but you
can submit a query from the shell command line and
redirect the results to the printer.  See the
documentation regarding command-line option -e for
mysql.

Since you the size and format of the query result may
not fit nicely on your pages, I suggest one of the
following:

1.  Submit the query from the shell command line and
redirect the result to a file for further formatting.

2.  Use SELECT...INTO... from within mysql to redirect
the query results to a file.

3.  Use a client program that has printing functions.

Best of luck,

Andrew Gould

--- Khuon Tech <tktech@xxxxxxxxxxxx> wrote:
> 
> Hi all,
> 
> My server is RH6.2 and using MySQL. I'm newbie to
> MySQL.
> Can I print the results from query I did ? How can I
> do that ?
> 
> mysql>select * from mytable;
> ............................ <-- the results are
> here
> mysql>    <<=== Can I type the command to print
> above results from here ?
> 
> Thank in advance.
>
____________________________________________________________________
> 
> TK Tech
> A newbie who learns to swim in the LINUX sea.
> A guy who jumps in the black hold and gets out with
> the bright mind.
> 
> 
> -- 
>
---------------------------------------------------------------------
> Please check
> "http://www.mysql.com/documentation/manual.php";
> before
> posting. To request this thread, e-mail
> mysql-thread60351@xxxxxxxxxxxxxxx
> 
> To unsubscribe, send a message to:
>    
>
<mysql-unsubscribe-andrewgould=yahoo.com@xxxxxxxxxxxxxxx>
> 
> 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
> 
> .
> ysql.com/php/unsubscribe.php
> 
> .
> 


__________________________________________________
Do You Yahoo!?
Yahoo! Photos - Share your holiday photos online!
http://photos.yahoo.com/

-- 
---------------------------------------------------------------------
Please check "http://www.mysql.com/documentation/manual.php"; before
posting. To request this thread, e-mail mysql-thread60352@xxxxxxxxxxxxxxx

To unsubscribe, send a message to:
    <mysql-unsubscribe-treed=ultraviolet.org@xxxxxxxxxxxxxxx>

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