USE my_guitar_shop;


LOAD DATA LOCAL INFILE '/Users/kevintrainor/__mgs_dump_restore_load_db/administrators.csv'
INTO TABLE administrators
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
ESCAPED BY '\\'
IGNORE 1 LINES;

LOAD DATA LOCAL INFILE '/Users/kevintrainor/__mgs_dump_restore_load_db/categories.csv'
INTO TABLE categories
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
ESCAPED BY '\\'
IGNORE 1 LINES;

LOAD DATA LOCAL INFILE '/Users/kevintrainor/__mgs_dump_restore_load_db/products.csv'
INTO TABLE products
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
ESCAPED BY '\\'
IGNORE 1 LINES;

LOAD DATA LOCAL INFILE '/Users/kevintrainor/__mgs_dump_restore_load_db/customers.csv'
INTO TABLE customers
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
ESCAPED BY '\\'
IGNORE 1 LINES;

LOAD DATA LOCAL INFILE '/Users/kevintrainor/__mgs_dump_restore_load_db/addresses.csv'
INTO TABLE addresses
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
ESCAPED BY '\\'
IGNORE 1 LINES;

LOAD DATA LOCAL INFILE '/Users/kevintrainor/__mgs_dump_restore_load_db/orders.csv'
INTO TABLE orders
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
ESCAPED BY '\\'
IGNORE 1 LINES;

LOAD DATA LOCAL INFILE '/Users/kevintrainor/__mgs_dump_restore_load_db/order_items.csv'
INTO TABLE order_items
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
ESCAPED BY '\\'
IGNORE 1 LINES;
