exporting data from mysql database
Posted: Tue Jan 09, 2007 1:06 am
hi......
im using this command to take the data from my table in mysql
$sql1="SELECT * into outfile '/tmp/text' from websites ";
and when i add a new data to the table and try to use this command a gain i it give me this error
Error: File '/tmp/text' already exists
but i must overwrite on the same file text so any body have any idea
im using this command to take the data from my table in mysql
$sql1="SELECT * into outfile '/tmp/text' from websites ";
and when i add a new data to the table and try to use this command a gain i it give me this error
Error: File '/tmp/text' already exists
but i must overwrite on the same file text so any body have any idea