How to import CSV file to MySql Database using PhpMyadmin

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.

Import csv file to 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.

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Scroll To Top