Csv a Mysql

//Importar csv a mysql

LOAD DATA INFILE 'c:/keys2.csv' INTO TABLE tb_keys
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
(keyid,estado)
SET idtb_keys = NULL;

select estado from tb_keys where estado not like '%o' set estado = 'activo'

update tb_keys set estado = 'activo' where estado not like '%o'


=======================================================

LOAD DATA INFILE 'c:/data.csv' INTO TABLE population
SET id = NULL;