I can guide you on how to import a CSV file into MySQL Workbench and provide a sample dataset in CSV format. Unfortunately, I can't create videos, but I'll provide step-by-step instructions.

Sample CSV File:

Let's create a simple CSV file named sample_data.csv with the following content:

id,name,age,city
1,John,25,New York
2,Jane,30,San Francisco
3,Bob,22,Los Angeles
4,Alice,28,Chicago
5,Charlie,35,Miami

Steps to Import CSV into MySQL Workbench:

Open MySQL Workbench:
- Launch MySQL Workbench on your computer.
Connect to a Server:
- Connect to the MySQL server where you want to import the data.
Open a Query Tab:
- Click on the "Query" tab to open a new SQL query tab.
Use LOAD DATA INFILE:
- You can use the LOAD DATA INFILE statement to import data from a CSV file. Example:
```
LOAD DATA INFILE 'path/to/sample_data.csv'
INTO TABLE your_table_name
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 ROWS; -- Skip the header row if it exists
```
Replace 'path/to/sample_data.csv' with the actual path to your CSV file, and your_table_name with the desired table name.
Run the Query:
- Highlight the query and click on the "Execute" button to run it.

Additional Tips:

Ensure that the MySQL server has the necessary permissions to read the CSV file.
Check the file path, and use forward slashes (/) in the file path even on Windows (e.g., C:/path/to/sample_data.csv).
Make sure the table structure matches the columns in your CSV file.

Try these steps, and let me know if you encounter any specific issues. If you have a more detailed question or specific error message, I can provide further assistance.

Dataset for Lec3 (DML & DDL)