Today we will check how import csv file to MySQL database using phpmyadmin.Its very easy to upload csv file using phpmyadmin.You will import any data from CSV to your database.
Follow these steps:-
1.Login to your phpmyadmin.
2.Goes to Import option of your table.
3. Select CSV file which you want to import.
4. Select CSV using LOAD DATA.
5. Fields terminated by:- |
6.Fields enclosed by(Lets remain in default or leave blank ).
7. Fields escaped by(Lets remain in default or leave blank ).
8. Leave everything else to default value and click submit.