How can I load data from a text file into a table?

We can use LOAD DATA INFILE file_name;
syntax to load data
from a text file. but we have to make sure that
a) data is delimited
b) columns and data matched correctly