update 语句示例: UPDATE `zjzc`.`QRTZ_SCHEDuler_state` SET `ip`='220.191.34.246' WHERE `sn`='3117764' and`startTime`='2016-07-20 00:02:40'; UPDATE QRTZ_SCHEDULER_STATE SET LAST_CHECKIN_TIME = 1472174086295 WHERE SCHED_NAME = 'ReportControlScheduler' AND INSTANCE_NAME = 'auto' if (( $_ =~/$bs+$c/i ) or ($_ =~/$bs+`zjzc`.`$c`/i) ) wjdb3:/root/sbin# cat a3.pl my $str="UPDATE QRTZ_SCHEDULER_STATE SET"; my $a="$ARGV[0]"; my $b="$ARGV[1]"; if ($str=~/$as+$b/i ){print "111111111 "}; if ($str=~/$as+`zjzc`.`$b`/i ){print "22222222 "}; wjdb3:/root/sbin# perl a3.pl UPDATE QRTZ_SCHEDULER_STATE 111111111 s Match a whitespace character 匹配空白字符 wjdb3:/root/sbin# cat a3.pl my $str="UPDATE `zjzc`.`QRTZ_SCHEDuler_state`"; my $a="$ARGV[0]"; my $b="$ARGV[1]"; if ($str=~/$as+$b/i ){print "111111111 "}; if ($str=~/$as+`zjzc`.`$b`/i ){print "22222222 "}; wjdb3:/root/sbin# perl a3.pl UPDATE QRTZ_SCHEDULER_STATE 22222222