CODE EXAMPLE FOR SQL

load data from text file to mysql database on mac terminal

LOAD DATA INFILE '/tmp/mydata.txt' INTO TABLE PerformanceReport;