importing csv data that includes PASSWORDS 1

[admoore]

I have a simple .csv file and wrote a little php file to import it into a MySQL table; however, one field needs to be password hashed and I am having trouble with the syntax to do this...

Here is what I tried:

     $result = mysql_query("LOAD DATA
                       INFILE  '/path/file.csv'
                       INTO TABLE users
                       FIELDS TERMINATED BY ','
                              ENCLOSED BY '\"'
                       (`user`, password(`password`))
                      ");

But, needless to say; I have issues...
Could somebody kindly help me out here with my syntax???

TIA,
-A

 

[TonyGroves]

You can't import the file directly into the table; you would have to load the file into a temporary table and then into the real table:
[tt]
CREATE TEMPORARY TABLE t (u CHAR(20),p CHAR(20));

LOAD DATA INFILE '/path/file.csv'
INTO TABLE t
FIELDS TERMINATED BY ',' ENCLOSED BY '\"';

INSERT users (user,password)
SELECT u,PASSWORD(p) FROM t;

DROP TABLE t;
[/tt]