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;