INSERT IGNORE INTO countries ( id , name , iso ) VALUES ( 1 , 'Afghanistan', 'AF' ) ,( 2 , 'Albania', 'AL' ) ,( 3 , 'Algeria', 'DZ' ) ,( 4 , 'Andorra', 'AD' ) ,( 5 , 'Angola', 'AO' ) ON DUPLICATE KEY UPDATE name = values(name) , iso = values(iso);