逃避shell变量单引号 [英] escape single quote in shell variable

问题描述

我写了一个bash脚本插入值 sqlite的数据库。该命令如下

I wrote a bash script to insert values to sqlite database. The command is as follow

sqlite3 ${db_name} "insert into ${table_name} (${column1},${column2}) values ('$f1','$f2');"

此命令运行正常，直到 F1 变量包含一个单引号

This command works fine until f1 variable contains a single quote

# e.g f1="I'm just kidding"
# the command reported error
Error: near "m": syntax error

可能有人请告诉我如何才能逃脱变量中的单引号？
任何建议AP preciated。谢谢！

May someone please show me how can we escape the single quote inside the variable? Any recommendations are appreciated. Thanks!

推荐答案

要逃避SQL单引号，你双击它（的 https://www.sqlite.org/faq.html#q14 ）：

To escape a single quote for SQL, you double it (https://www.sqlite.org/faq.html#q14):

$ f1="I'm just kidding"
$ echo "${f1//\'/''}"
I''m just kidding
$ f2="no single quotes"
$ echo "${f2//\'/''}"
no single quotes

所以

sqlite3 ${db_name} "insert into ${table_name} (${column1},${column2}) values ('${f1//\'/''}','${f2//\'/''}');"

这篇关于逃避shell变量单引号的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！