Import csv to MySQL

Step 1: You have to copy the file to a specific location as other locations are prevented by default due to security constraints. To find out the location issue this query against MySQL database.
SHOW VARIABLES LIKE “secure_file_priv”;
The result was C:\ProgramData\MySQL\MySQL Server 8.0\Uploads\ for me.
Then copy the .csv file to that path and then issue LOAD DATA INFILE command to import the file to the database.

mysql -u admin -p “Password@123456” --execute="LOAD DATA INFILE ‘C:\ProgramData\MySQL\MySQL Server 8.0\Uploads\Trade.csv’ IGNORE INTO TABLE Trade FIELDS TERMINATED BY ‘,’ LINES TERMINATED BY ‘\n’ ;