LOAD DATA INFILE 'd:/t2c/teste.csv' INTO TABLE incoming FIELDS TERMINATED
BY ','
-> (@msisdn,@alias,@data,@hora,@lenght)
-> set idOperador = 4,
-> lenght = 1,
-> msisdn = @msisdn,
-> deliveryDate = str_to_date(@data + " " + @hora,%Y %m %d %H %i %S),
-> receivedDate = str_to_date(@data + " " + @hora,%Y %m %d %H %i %S),
-> laNumber = 300,
-> alias = @alias;
I have several other columns on my table but all accept null values, so i didn't set them.
I have this error.
ERROR 1064 (42000): 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 '%Y %m
%d %H %i %S),
receivedDate = str_to_date(@data + " " + @hora,%Y %m %d %H %' at line 6
Can you help me ?