need help on load data infile

[pixeltrace]

guys,

 

i need help, i usually uploads csv to our database and currently this is my code

LOAD DATA INFILE 'test_users.csv' 
INTO TABLE test 
FIELDS 
    TERMINATED BY ',' 
    OPTIONALLY ENCLOSED BY '"' 
    ESCAPED BY '\\' 
LINES TERMINATED BY '\n'
(id, name, username, email, md5(password), usertype, block, sendEmail, gid, registerDate, lastvisitDate, activation, params);

 

this one is working if i replaced md5(password) with just password

my problem now, i need the password to be in md5 format.

 

what is the correct code for this?

 

thanks!

[bubblegum.anarchy]

What exactly is not working?

[pixeltrace]

on the md5(password)

 

if i change it to

password

 

it can be imported successfully

however

the password is not converted to md5

 

 

what is the correct code for this?

 

thanks!

[Illusion]

Use UPDATE statement to use md5() function on password column once the file was loaded.

[pixeltrace]

hi,

 

is there no other way? because this is what i do after loading.

 

thanks!

[bubblegum.anarchy]

I mean - what error do you get when using md5() ?