CREATE TABLE new LIKE cat_roles;

LOAD DATA INFILE ‘C:\\wamp64\\tmp\\data\\permisos\\cat_roles.csv’ IGNORE INTO TABLE new FIELDS TERMINATED BY ‘,’ ENCLOSED BY ‘"’ LINES TERMINATED BY ‘\r\n’ IGNORE 1 ROWS (id_rol,nivel,rol,grupo,abreviatura,unico,instanciable,especial,por_unidad,division_id,direccion_id);

RENAME TABLE cat_roles TO old, new TO cat_roles; DROP TABLE old;