SQL Interview Preparation – Advanced Level

Question: Import CSV Data

Understand how to import CSV files into MySQL databases to update supplier metrics without altering existing records. This lesson guides you through practical steps to handle CSV data import, supporting delivery and performance analysis.

We'll cover the following...

Question
Expected output
Try it yourself
Hints

Field	Type
`SupplierID`	`int`
`SupplierName`	`varchar(50)`
`Email`	`varchar(50)`
`Phone`	`varchar(15)`
`Address`	`varchar(100)`
`OnTimeDeliveryRate`	`decimal(5,2)`
`AvgLeadTime`	`int`

1.Get Started

2.Transactions and Execution Control

3.Stored Routines

4.SQL Flow Control and Validation

5.Advanced Database Objects

6.Query Plans and Performance

7.SQL Modes and Permissions

8.Data Import and Export

9.Final Remarks

Question: Import CSV Data

Question