Importing a CSV file into a MySQL table can be done using various methods, including the LOAD DATA INFILE statement and MySQL Workbench. Here’s a step-by-step guide to help you through the process.

Using LOAD DATA INFILE Statement

The LOAD DATA INFILE statement is a powerful way to import data from a CSV file into a MySQL table. Here’s how you can do it:

1. Prepare the Table and CSV File: Ensure you have a table that matches the structure of your CSV file. For example, create a table named discounts: CREATE TABLE discounts ( id INT NOT NULL AUTO_INCREMENT, title VARCHAR(255) NOT NULL, expired_date DATE NOT NULL, amount DECIMAL(10, 2) NULL, PRIMARY KEY (id) );

2. Check Secure File Privileges: Verify the directory where MySQL can read files using: SELECT @@secure_file_priv;

3. Copy the CSV File: Place your CSV file in the directory specified by the secure_file_priv variable.

4. Import the CSV File: Use the LOAD DATA INFILE statement to import the data: LOAD DATA INFILE 'C:/ProgramData/MySQL/MySQL Server 8.0/Uploads/discounts.csv' INTO TABLE discounts FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' IGNORE 1 ROWS;

5. Verify the Import: Check the data in the table to ensure it was imported correctly: SELECT * FROM discounts;