> Another thing bogging me down is importing text file in mysql database.
> The fields are delimited by tab.
> In the load data local infile command i'm mentioning '\t' as field
> delimiter, which is importing fine, for most of the data, except for
> the data containing \ encountering which the data of next field is
> missed.
>
> Any idea regarding this peculiar issue ??
>

Not sure if I'm getting your question here, but this most probably
sounds like an issue with escape missing escape characters. Try
importing a simpler formatted text file and that would help you in
understanding your problem.

--
Sharninder