Import mysql database from file to table

How to import data from a text file into a databse table

akonkol
April 4, 2012



load data local infile "%{path_to_file}%/%{filename}%'
into table %{table_name}%
FIELDS TERMINATED BY '~~' 
LINES TERMINATED BY '&*' ;