mysql匹配更新_mysql 匹配update

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 (( $_ =~/$b\s+$c/i ) or ($_ =~/$b\s+`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=~/$a\s+$b/i ){print "111111111\n"};

if ($str=~/$a\s+`zjzc`.`$b`/i ){print "22222222\n"};

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=~/$a\s+$b/i ){print "111111111\n"};

if ($str=~/$a\s+`zjzc`.`$b`/i ){print "22222222\n"};

wjdb3:/root/sbin# perl a3.pl UPDATE QRTZ_SCHEDULER_STATE

22222222