Overview This task involves loading a CSV file into MySQL. Environment This task

Question

Overview

This task involves loading a CSV file into MySQL.

Environment

This task is running against a live MySQL server.

-- We've already created this database for you

SQL

USE assessment;

-- Drop and recreate the products table

DROP TABLE IF EXISTS products;

CSV

1,Chai
2,Chang
3,Aniseed Syrup
4,Chef Anton's Cajun Seasoning
5,Chef Anton's Gumbo Mix
6,Grandma's Boysenberry Spread

CREATE TABLE products (

ProductID int,

ProductName varchar(255)

);

-- TASK: Import /src/test_data.csv into products table

-- INSERT SOLUTION HERE

SELECT * FROM products;

This task involves loading a CSV file into MySQL.

Explanation / Answer

CREATE TABLE products (

ProductID int,

ProductName varchar(255)

);

-- TASK: Import /src/test_data.csv into products table

-- INSERT SOLUTION HERE

SELECT * FROM products;

Related Questions

Navigate

• Browse (All)
• Browse O
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.