Fri, 17 May 2024


How to load data from CSV or any other character delimited file in a MySQL table?

By: Nathalie, NetArt Media
Mon, 27 April 2020

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


Category: Databases
Share this post:



See All Scripts






Subscribe for our newsletter

Receive the latest blog posts direct in your mailbox