importing text file

[jesus_hairdo]

I have a textfile which i want to import into a database,
using this sql query
"load data infile '/var/www/html/test/btpaydec01.txt' into table disk_conversion.BTPay fields terminated by ',' ignore 2 lines"

The only problem I have is that i have an ID field as the 1st field in the database which isn't present in the text file. How can I get around this?

thanks

Jamie

[shmony]

well, I think that in the .txt file, at the first column for the id, put \n in that column. it means null. I hope that helped.

[jesus_hairdo]

That is one way around it, but ideally i need to do it without editing the text file at all, hopefully end users will be able import these file so the less they have to do the better!!
I was hoping that i could do it in sql, looks like i'll have to process using php instead.

thanks

Jamie