use cs304_db;

-- optionally, delete all existing data
delete from car_sales;

-- load new data from TSV file

load data local infile 'car-sales.tsv'
into table car_sales
ignore 1 lines;

-- show data

select * from car_sales;