# --------------------------
   # prepare the SQL
   my $sqlq= "insert into interesting_interfaces ".
             "(datetime_created, datetime_last_update, device, interface_id, interface, auto_interesting) ".
             "values (now(), now(),?,?,?,?) ".
             "on duplicate key update datetime_last_update = now(), interface_id = ?,  ".
             "auto_interesting=?";

   my $insert = $dbh->prepare($sqlq);
 
   $insert->execute($dev,$num,$name,$auto,$num,$auto);
   if ($insert->errstr ne '')
   {
      print "$dev,$name - ($dev,$num,$name,$auto,$num,$auto) caused the following error:\n";
      print $insert->errstr."\n"
   }
   else {  print "$dev,$name - ($dev,$num,$name,$auto,$num,$auto) successful:\n"; }

Prepare sql in advance

mysql

SQL