LOAD DATA INFILE from a csv file

Tech Talk Databases
1

Here is the code for loading from a CSV file


LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name.txt'
    [REPLACE | IGNORE]
    INTO TABLE tbl_name
    [FIELDS
        [TERMINATED BY '	']
        [[OPTIONALLY] ENCLOSED BY '']
        [ESCAPED BY '\\' ]
    ]
    [LINES 
        [STARTING BY '']    
        [TERMINATED BY '
']
    ]
    [IGNORE number LINES]
    [(col_name,...)]

Here is an example


mysql -uUSERNAME -pPASSWORD -e "LOAD DATA INFILE 'PATH/FILENAME' INTO TABLE TABLE FIELDS TERMINATED BY ',' (die,loc)" Database