清华大佬耗费三个月吐血整理的几百G的资源,免费分享!....>>>
#!perl
use strict;
use warnings;
#原始字符串
my $src_str='select username,
userid,
deptid,
roleid
from user u,role r,dept d
where u.deptid=d.id
and u.roleid=r.id
and u.userid=\'zhang\'';
#原始连接符
my $src_conn="\n";
#目标字符串标示符
my $target_quote='"';
#目标连接符
my $target_conn="+\n";
print join $target_conn,map {$target_quote.$_.$target_quote} split(/$src_conn/,$src_str);