Category: Databases
Mysql table export problem
I am trying to export table with following command.
$query = "SELECT * FROM $userstable ORDER BY ID INTO OUTFILE 'file.out' FIELDS TERMINATED BY '|'";
PRINT "$query";
$result = MYSQL_QUERY($query);
PRINT "***** $result *******";
I am getting following message in browser:
SELECT * FROM information1 ORDER BY ID INTO OUTFILE 'out.file' FIELDS TERMINATED BY '|'***** *******
It means query is not performed.
Need some help to solve the problem. Also where will file 'out.file' be created. In the same directory?
[This message has been edited by ads (edited February 16, 2000).]