ebta/load-data-local.md

## load-data-local.md

      
    Raw
  

              load-data-local.md
            
          
    First, accesss mysql command line using user and password :
mysql -u user -p

Run from mysql> prompt
SET GLOBAL local_infile=1;
quit;

Run again mysql command line
mysql --local-infile=1 -u root -p

Then load your csv files like this
LOAD DATA LOCAL INFILE '/home/user/your-files.csv'
INTO TABLE score_esay
FIELDS TERMINATED BY ',' ENCLOSED BY '"'
LINES TERMINATED BY '\r\n'
IGNORE 1 ROWS
(col1,col2,col3,col4);

LOAD DATA LOCAL INFILE '/home/user/your-files.csv'
INTO TABLE score_esay
FIELDS TERMINATED BY ',' ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 ROWS