entering "null" in empty field using LOAD DATA INFILE

[sadhiesh]

hai
when i use LOAD DATA INFILE for a text file delimited by tab, and if it has any field empty it enters " as default, instead i want string 'null' to be entered.This should be done without altering the text file from which data is loaded.it loads 80000+records hence using query statement will delay the process.so if u find a way please help me out providing the solution.

thanks in advance & with regards
Sadhiesh Babu.D

 

[QuintonV]

I dont knowe how to do what youre asking but why not just run a update on the empty fields once you have imported them to set there values to null? If its only around 8000 records it shouldnt take long at all to update the fields

Quinton