How to import CSV file into MySQL using phpMyAdmin?

[Dipak Bhoi]

Hello folks,

It's pretty simple to import/upload .csv file in MySQL table using phpMyAdmin. Just follow steps:

Login to your cPanel and go to phpMyAdmin.

    1. Select the database and then table from left side panel.
    2. Click on Import tab.
    3. Click the Choose file button to browse to local csv file.
    4. Select the 'CSV using LOAD DATA' for Format.
    5. Choose other Format-Specific Options.
    5. Click Go