• eval 捕获错误


    eval 捕获错误:
    [root@dr-mysql01 ~]# cat t1.pl 
    use DBI;
    my $dbUser='zabbix';
    my $user="root";
    my $passwd="1234567";
    my $dbh  = DBI->connect("dbi:mysql:database=zabbix;host=192.168.32.55;port=3306",$user,$passwd) or die "can't connect to database ". DBI-errstr;
    eval {
    #alter table trends drop partition p20160425;
    my $sql="alter table history  drop partition p20160501;";
    print "$sql is $sql
    ";
    $dbh->do("$sql");
        };
          print $@;
    [root@dr-mysql01 ~]# perl t1.pl 
    $sql is alter table history  drop partition p20160501;
    
    
    [root@dr-mysql01 ~]# cat t1.pl 
    use DBI;
    my $dbUser='zabbix';
    my $user="root";
    my $passwd="1234567";
    my $dbh  = DBI->connect("dbi:mysql:database=zabbix;host=192.168.32.55;port=3306",$user,$passwd) or die "can't connect to database ". DBI-errstr;
    eval {
    #alter table trends drop partition p20160425;
    my $sql="alter table history  drop partition p20160401;";
    print "$sql is $sql
    ";
    $dbh->do("$sql");
        };
          print $@;
    [root@dr-mysql01 ~]# perl t1.pl 
    $sql is alter table history  drop partition p20160401;
    DBD::mysql::db do failed: Error in list of partitions to DROP at t1.pl line 10.

  • 相关阅读:
    LeetCode18. 四数之和
    15. 三数之和
    LeetCode202. 快乐数
    LeetCode1. 两数之和
    LeetCode349. 两个数组的交集
    LeetCode242. 有效的字母异位词
    VSCode运行时弹出powershell
    关于cin, cin.get(), getchar(),getline()的字符问题
    剑指 Offer 27. 二叉树的镜像
    BFS zoj 1649
  • 原文地址:https://www.cnblogs.com/hzcya1995/p/13350740.html
Copyright © 2020-2023  润新知