i have some problems in this code, especially in the query, because every time that i run it in php, it always shows "Invalid DATA LOAD query".
i have run this query in mysql prompt and it run without any problem, but give me some warnings (don´t know why) the same number of warnings as the number of rows that i have in the 'out.txt'
$result = mysql_db_query('$dbName',"LOAD DATA LOCAL INFILE 'out.txt' REPLACE INTO TABLE exist FIELDS TERMINATED BY ','") or die ("Invalid DATA LOAD query");
by the way, do you know how can i see warnings in mysql prompt i'm using 4.0.11 version of mysql in the help they say to use \W to show warnings but i use it and i continue without see warnings but it works just fine
mysql>\W
Show warnings enable.
mysql> LOAD LOCAL DATA INFILE '/temp/out.txt' REPLACE INTO TABLE exist FIELDS TERMINATED BY ',';
bla bla bla ... and no warnings
mysql>_
Does that mean bla bla bla actually stands for an error message?
If there are syntax errors you won't get warnings because the syntax error stops processing the statement before warnings may occur.
So, bla bla bla translates to ...?
volka wrote:Does that mean bla bla bla actually stands for an error message?
If there are syntax errors you won't get warnings because the syntax error stops processing the statement before warnings may occur.
So, bla bla bla translates to ...?