1. Open the command prompt
2. Go to mysql folder ( C:\xampp\mysql\bin>mysql -u root -p )
3. Select database by command: >use database_name
4. Run the below command:
-> load data
-> infile ‘D:/folder/filename.csv’
-> into table table_name fields terminated by ‘,’
-> enclosed by ‘”‘ lines terminated by ‘\n’;