doubei8541 2016-07-17 00:46
浏览 211
已采纳

如何将shell脚本写入多行文本从mysql读取文件?

I am facing a problem while writing a shell script. i have table in a database where there is a text field.. i need to write that field into a file.

database fields are id, file_name, text

here is my script

#!/bin/bash
while read -a row
do
cat <<EOF >/root/${row[1]}
${row[2]}
EOF
sleep 1
done < <(echo "SELECT * FROM installation WHERE status = 1" | mysql -h 127.0.0.1 -u root -padmin -D data -s)

I have tried with

echo "${row[2]}" > /root/${row[1]}

But its writing the 1st line only, but the text field is multiline text and i need write full text in that file

please help

  • 写回答

1条回答 默认 最新

  • doudi7782 2016-07-17 01:24
    关注

    By default read -r row will do word splitting by space/tab/new-line. Because the text field from table contains new-lines, word splitting would cut your text result. In this situation it's hard to avoid it.

    I recommend you should replace the new-line to another mark, e.g. ### or just new-line, using REPLACE(text, " ", 'new-line')(I am not familiar with sql REPlACE function) in SQL, then get result from shell, then use ${row[2]//new-line/$' '} to convert the new-line back.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 lammps Gpu加速出错
  • ¥15 关于PLUS模型中kapaa值的问题
  • ¥15 关于博途V17进行仿真时无法建立连接问题
  • ¥15 请问下这个红框里面是什么文档或者记事本编辑器
  • ¥15 机器学习教材中的例题询问
  • ¥15 求.net core 几款免费的pdf编辑器
  • ¥15 为什么安装HCL 和virtualbox之后没有找到VirtualBoxHost-OnlyNetWork?
  • ¥15 C# P/Invoke的效率问题
  • ¥20 thinkphp适配人大金仓问题
  • ¥20 Oracle替换.dbf文件后无法连接,如何解决?(相关搜索:数据库|死循环)