Databases - How to load data from CSV or any other character delimited file in a MySQL table?
To do that, you may use the following query: LOAD DATA INFILE 'Input.txt' INTO TABLE MyInputTable FIELDS TERMINATED BY '~'; where ~ could be whatever char delimiter you might have