### LOAD DATA FROM FILE
### This is working in MySQL Query Browser on Windows
LOAD DATA LOCAL INFILE "C:\\Documents and Settings\\benjo\\Desktop\\keys.csv"
INTO TABLE keys_allowed
FIELDS TERMINATED BY ';'
LINES TERMINATED BY '\n'
(key, user);

mysql query to populate table from data in file

mysql, file, csv

SQL