my $IP = "172.16.2.163"; my $user = "root"; my $table = "user_master"; my $dbh = DBI->connect("DBI:mysql:database=$db;host=$IP;mysql_socket=/opt/lampstack-5.5.27-0/mysql/tmp/mysql.sock","$user","",{'RaiseError' => 1}); my $user_sth = $dbh->prepare("insert into user_master (msisdn,cat0,cat1,cat2,cat3,cat4,cat5,cat6,cat7,vip,SAcode,phone_type) values (?,?,?,?,?,?,?,?,?,?,?,?) on duplicate key update cat0=0"); $user_sth->execute($msisdn,@db_values,0,$SAC,$phone_type) or die $DBI::errstr;