too long

Question

I am trying to insert the current date and time to through a Load Data Local Inline statement. Would like to insert the current date and time through the command. Getting the following error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@Date_Update=date('Y-m-d')' at line 3.

Here is my statement.

 $sqlstatement="LOAD DATA LOCAL INFILE '$temp' INTO TABLE contacts 
FIELDS TERMINATED BY ',' 
LINES TERMINATED BY '' 
IGNORE 1 LINES
    (User_Category, Name, Logon_id, @Date_Update)
    SET ID=@ID, @Date_Update=date('Y-m-d');
    ";

Is setting the current date possible wih Load Data Local Infile?

Answer 1

I think the problem is the wrong assignation of the fields :

$sqlstatement="LOAD DATA LOCAL INFILE '$temp' INTO TABLE contacts 
FIELDS TERMINATED BY ',' 
LINES TERMINATED BY '' 
IGNORE 1 LINES
    (User_Category, Name, @Logon_id, @Date_Update)     ◄■■■■■■■■■■■■■■■■
    SET ID=@Logon_id, Date_Update=NOW();               ◄■■■■■■■■■■■■■■■■
    ";