Bash Script SQLITE - Too Many Options

Question

Can't figure this one out, if I execute the command directly in the shell, then it executes successfully, but running from a script file I get the following error:

sqlite3: Error: too many options: "INTO"

#!/bin/bash
sql="\"INSERT INTO keys ('date','chan','key','name','desc','ser','ep','cat') VALUES('xxx','xxx','xxxx','xxxx','xxxxx.','xxx','xxx','xxxx');\""      
echo $sql
sqlite3 mydb.db $sql

Any ideas on what the problem might be ?

Double quote the $sql variable in the script: sqlite3 mydb.db "$sql" — dinox0r
– dinox0r, Commented Oct 14, 2013 at 1:07

dinox0r · Accepted Answer · 2013-10-14 13:00:50Z

2

Double quote the $sql variable in the script:

#!/bin/bash
sql="\"INSERT INTO keys ('date','chan','key','name','desc','ser','ep','cat') VALUES('xxx','xxx','xxxx','xxxx','xxxxx.','xxx','xxx','xxxx');\""      
echo $sql
sqlite3 mydb.db "$sql"

answered Oct 14, 2013 at 13:00

dinox0r

16.1k4 gold badges39 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Drey · Accepted Answer · 2016-04-25 03:35:48Z

0

In my case the problem was in the binary I execute:

cat  /opt/sbin/sqlite3:
#!/bin/sh
export LD_LIBRARY_PATH="/opt/lib:$LD_LIBRARY_PATH"
/opt/sbin/sqlite3.real $@

So if I execute /opt/sbin/sqlite3.real I have no problems.

answered Apr 25, 2016 at 3:35

Drey

3873 silver badges10 bronze badges

Collectives™ on Stack Overflow

Bash Script SQLITE - Too Many Options

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related