MySql: Insert values into Table from File Example

Inserting huge data into myql database is very simple if your data is in a file separated with delimiters. For example if you have a CSV ( Comma Separated Values) file, then you can use the below syntax to load data from the csv file into mysql table.



Consider you have a csv file named 'test.csv' with the following content,



01,SHARON,FEMALE,20

02,NAVEEN,MALE,24

03,ANITA,FEMALE,22

04,