sql_shell.sh脚本内容:
while read str
do
echo "each sql str is :${str}"
done < sql_file.txt
sql_file.txt文件中的内容为:
SELECT * FROM VV_V13 A WHERE(A.NAME IS NULL OR A.NAME='')
SELECT * FROM VV_V14 A WHERE NOT REGEXP_LIKE(EMAIL,'^\w+((-\w+)|(\.\w+))*\@[A-Za-z0-9]+((\.|-)[A-Za-z0-9]+)*\.[A-Za-z0-9]+$')执行脚本的输出:
each sql str is :SELECT * FROM VV_V13 A WHERE(A.NAME IS NULL OR A.NAME='')
each sql str is :SELECT * FROM VV_V14 A WHERE NOT REGEXP_LIKE(EMAIL,'^w+((-w+)|(.w+))*@[A-Za-z0-9]+((.|-)[A-Za-z0-9]+)*.[A-Za-z0-9]+$')执行脚本后,发现输出txt文件中第二行中的反斜杠\不见了,请问这应该怎么解决啊?
while read str
do
echo "each sql str is :${str}"
done < sql_file.txt
sql_file.txt文件中的内容为:
SELECT * FROM VV_V13 A WHERE(A.NAME IS NULL OR A.NAME='')
SELECT * FROM VV_V14 A WHERE NOT REGEXP_LIKE(EMAIL,'^\w+((-\w+)|(\.\w+))*\@[A-Za-z0-9]+((\.|-)[A-Za-z0-9]+)*\.[A-Za-z0-9]+$')执行脚本的输出:
each sql str is :SELECT * FROM VV_V13 A WHERE(A.NAME IS NULL OR A.NAME='')
each sql str is :SELECT * FROM VV_V14 A WHERE NOT REGEXP_LIKE(EMAIL,'^w+((-w+)|(.w+))*@[A-Za-z0-9]+((.|-)[A-Za-z0-9]+)*.[A-Za-z0-9]+$')执行脚本后,发现输出txt文件中第二行中的反斜杠\不见了,请问这应该怎么解决啊?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货