- or download this
#!/usr/bin/perl
...
$tablename = '';
$tablename = $1 if $stmt0 =~ m/^.*FROM\s+(\S+)\s*.*;$/s;
print "table name =\"$tablename\"\n";
- or download this
$tablename = $1 if $stmt =~ m/^.*FROM\s+(\S+)\s*.*$/gs;
- or download this
$tablename = $1 if $stmt =~ m/^.*FROM\s+(\S+)\s*.*$/gs;
$tablename =~ s/;//;