How to Import Excel file data in MySql table

Step-1: Create .CSV file of the data.

Step-2: Create data bse and table name in which you want to upload the data

Step-3: Run the following details of MySql Command Prompt:

mysql> LOAD DATA LOCAL INFILE 'C:\\emp.csv' INTO TABLE emp_details.emp_data FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\r\n' (id, name);