$insert = $dbh->prepare("INSERT INTO $table_name(s_no,c_type,jur,home,lni,citation,d_pattern,d_text) VALUES(?,?,?,?,?,?,?,?) ON DUPLICATE KEY UPDATE s_no = s_no,c_type = c_type, jur = jur, home = home, lni = lni,citation =citation,d_pattern= d_pattern,d_text= d_text") ; my $input_tuples = $insert->execute_array({ ArrayTupleStatus => \my @tuple_status },\@index_array,\@c_array,\@jur_array,\@home_array,\@l_array,\@c_array,\@in_array,\@p_array);