SQL to upload the smaller tables of the MOT test dataset

MOT_populate_db.sql

USE MOT;

LOAD DATA LOCAL INFILE '[yourpath \\ as separator in windows]failure_location.txt'
INTO TABLE failure_location
FIELDS TERMINATED BY '|'
LINES TERMINATED BY '\n'
;

LOAD DATA LOCAL INFILE '[yourpath \\ as separator in windows]item_detail.txt'
INTO TABLE testitem_detail
FIELDS TERMINATED BY '|'
LINES TERMINATED BY '\n'
;

LOAD DATA LOCAL INFILE '[yourpath \\ as separator in windows]item_group.txt'
INTO TABLE testitem_group
FIELDS TERMINATED BY '|'
LINES TERMINATED BY '\n'
;