¿Cómo resolverlo?

  Carga por lote LOAD DATA LOCAL INFILE 'C:/bd/R1.txt' INTO TABLE dpc.anam_nivs FIELDS TERMINATED BY '|' LINES TERMINATED BY '\n' ; para cargar por lote debemos aplicar  OPT_LOCAL_INFILE=1 En las opciones al generar la cadena de conexion de work bench update sin where  SET SQL_SAFE_UPDATES = 0;

306 SELECT < select_list > FROM Table_A A LEFT JOIN Table_B B ON A.Key = B.Key WHERE B.Key IS NULL Full image of join  From aticle :  http://www.codeproject.com/KB/database/Visual_SQL_Joins.aspx