On 5/5/06, Rhino <[EMAIL PROTECTED]> wrote:
- Original Message -
From: "Payne" <[EMAIL PROTECTED]>
To:
Sent: Friday, May 05, 2006 12:09 AM
Subject: Output to a file
> Hey,
>
> been trying to output a select statment to a file, all the books I have
> only show how to input from a file
- Original Message -
From: "Payne" <[EMAIL PROTECTED]>
To:
Sent: Friday, May 05, 2006 12:09 AM
Subject: Output to a file
Hey,
been trying to output a select statment to a file, all the books I have
only show how to input from a file, what is the correct way
I thought I could
Hi Payne.
Payne wrote:
Hey,
been trying to output a select statment to a file, all the books I
have only show how to input from a file, what is the correct way
I thought I could do select * from my_toy >> `/tmp/my_toys`
You can do 'select * into outfile from ;'
But I get an error.
Payne wrote:
Hey,
been trying to output a select statment to a file, all the books I
have only show how to input from a file, what is the correct way
I thought I could do select * from my_toy >> `/tmp/my_toys`
But I get an error.
Payne
You can use the 'tee' command, eg:
tee logfile.t
Patrick,
Thursday, September 26, 2002, 3:38:24 PM, you wrote:
PF> I'm new to MySQL. I've been able to query the database via PHP and display
PF> it within a html page. I would like to out put the results to a flat file
PF> tab delimited instead of onto a new page.
Use SELECT INTO OUTFILE:
hi
hope this helps
Peter
';
$db = mysql_connect( "db", "**", "**");
mysql_select_db( "net3dual_reviews",$db);
$r = mysql_query("SELECT * FROM hwureviews ORDER BY num DESC LIMIT 7");
$max = mysql_query("select max(num) from hwureviews"
