Re: How to print in MySQL ?

[Khuon Tech <tktech@xxxxxxxxxxxx>]

Dear Arvind,

On Tue, 2 Jan 2001, Arvind Jalota wrote:

> you can run sql query & take output to as text in any file as
> 
> mysql -u username -p -d database name  -e 'select * from table name' >
> outputfile name.
 
I've tried it with some changes as below:

$ mysql -u username -p -d database name -e 'select * from table_name' >
outputfile_name;

$ It works great ;)

Thanks Arvind !

> It will work & provide yoy the result
> 
> 
> Arvind
> 
> ----- Original Message -----
> From: "Khuon Tech" <tktech@xxxxxxxxxxxx>
> To: "MySQL forum" <mysql@xxxxxxxxxxxxxxx>
> Sent: Tuesday, January 02, 2001 9:16 AM
> Subject: How to print in MySQL ?
> 
> 
> >
> > 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-thread60362@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