How to skip fields from text file while importing data into DB

[wakil ahamad]

How skip the text file fields while importing data into database table?

The syntax for loading data from file into DB is
load data local infile 'test.txt' into table customer
(customerID,name,msgto,msgfrom);

for example suppose a text file has seven fields:
uniqueid, customerID,name, guid, msgto, msgfrom,tag

customer table structure:

customerID varchar
name varchar
msgto varchar
msgfrom varchar

I would like to skip 'uniqueid', guid and 'tag' fields from text file
and only insert 5 fields into table mentioned above.