This code...
$q = "LOAD DATA INFILE '".str_replace("\\","/",$sqlfil["tmp_name"])."'
REPLACE INTO TABLE sortiment";
$res = mysql_query($q, $link_id);
print(mysql_affected_rows($link_id)."".str_replace("\\","/",$sqlfil["tmp_name"]));
...gives the output:
-1
C:/WINDOWS/TEMP/php1D0.tmp
Any ide
I have a called file cats.txt which count data that were solitary of a DB
Access.
I need to export these data for a table 'cats' inside of a DB done in MySql.
In MySql I can execute this procedure in the following way:
Load data local infile "gatos.txt"
into table gatos
fields
terminated by ','