Re: [sqlite] Need some help running sqlite3 command line

2017-03-07 Thread Chris Green
Jacob Sylvia wrote: > I know what the problem was... bash was interpreting the `table_name` piece > as a command. I had to escape the backticks... > Yes, `command` is the old-fashioned way of saying $(command) in bash. -- Chris Green ·

Re: [sqlite] Need some help running sqlite3 command line

2017-03-06 Thread Jacob Sylvia
te-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > > On Behalf Of Jacob Sylvia > > Sent: Monday, 6 March, 2017 17:10 > > To: SQLite mailing list > > Subject: Re: [sqlite] Need some help running sqlite3 command line > > > > So apparentl

Re: [sqlite] Need some help running sqlite3 command line

2017-03-06 Thread Keith Medcalf
.pem') WHERE ID=4;" > -Original Message- > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > On Behalf Of Jacob Sylvia > Sent: Monday, 6 March, 2017 17:10 > To: SQLite mailing list > Subject: Re: [sqlite] Need some help running sqlite3 command line &

Re: [sqlite] Need some help running sqlite3 command line

2017-03-06 Thread Jacob Sylvia
I know what the problem was... bash was interpreting the `table_name` piece as a command. I had to escape the backticks... This looks like it's going to work like a charm!!! I'll report back! ~Jake -- Jacob D. Sylvia Jake Sylvia's Consulting 430 Cole St. Seekonk, MA 02771 Cell: (508) - 954 -

Re: [sqlite] Need some help running sqlite3 command line

2017-03-06 Thread Richard Hipp
On 3/6/17, Jacob Sylvia wrote: > > How can I check if that support is compiled in? > The readfile() SQL function was add to the command-line shell in SQLite version 3.8.6 released on 2014-08-15. -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] Need some help running sqlite3 command line

2017-03-06 Thread Jacob Sylvia
gt; select writefile('privkey.bak', value) from table where key='privkey'; >> >> >> This is documented in section 6.1 of the CLI page >> https://www.sqlite.org/cli.html >> >> >> > -Original Message- >> > From: sqlite-users [mailto:sqlite

Re: [sqlite] Need some help running sqlite3 command line

2017-03-06 Thread Jacob Sylvia
key='privkey'; > > > This is documented in section 6.1 of the CLI page > https://www.sqlite.org/cli.html > > > > -Original Message- > > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > > On Behalf Of Jacob Sylvia > > Sent: S

Re: [sqlite] Need some help running sqlite3 command line

2017-03-06 Thread Keith Medcalf
ers [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > On Behalf Of Jacob Sylvia > Sent: Sunday, 5 March, 2017 17:39 > To: sqlite-users@mailinglists.sqlite.org > Subject: [sqlite] Need some help running sqlite3 command line > > Howdy all! > > I'm working on getting letsencr

Re: [sqlite] Need some help running sqlite3 command line

2017-03-06 Thread Hick Gunter
25 An: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> Betreff: Re: [sqlite] Need some help running sqlite3 command line I guess I should have mentioned that I'm trying to do this from a script, so that makes the command shell difficult. ~Jake -- Jacob D. Sylvia Jake Sylvia's Con

Re: [sqlite] Need some help running sqlite3 command line

2017-03-06 Thread Clemens Ladisch
Jacob Sylvia wrote: > The problem lies in the 'value' part. Because the text has line breaks / > carriage returns, I can't figure out how to do it appropriately from the > command line. Just use line breaks: $ sqlite3 ":memory:" "select 'first line > second line';" first line second line

Re: [sqlite] Need some help running sqlite3 command line

2017-03-06 Thread Jacob Sylvia
13:02 > An: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> > Betreff: Re: [sqlite] Need some help running sqlite3 command line > > Right... I know the syntax. The problem lies in the 'value' part. Because > the text has line breaks / carriage returns, I

Re: [sqlite] Need some help running sqlite3 command line

2017-03-06 Thread Hick Gunter
Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von Jacob Sylvia Gesendet: Montag, 06. März 2017 13:02 An: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> Betreff: Re: [sqlite] Need some help running sqlite3 command line Right... I know the

Re: [sqlite] Need some help running sqlite3 command line

2017-03-06 Thread Jacob Sylvia
Right... I know the syntax. The problem lies in the 'value' part. Because the text has line breaks / carriage returns, I can't figure out how to do it appropriately from the command line. I've tried setting the value in a bash variable, but the breaks get interpreted and the syntax fails. ~Jake

Re: [sqlite] Need some help running sqlite3 command line

2017-03-06 Thread Clemens Ladisch
Jacob Sylvia wrote: > Basically, I cant figure out how to update a text field in the sqlite > config database from the command line... sqlite3 config.db "UPDATE SomeTable SET SomeColumn = 'value' WHERE ID = 42" You need to know the database file name, the table name, the column name(s), the new

[sqlite] Need some help running sqlite3 command line

2017-03-06 Thread Jacob Sylvia
Howdy all! I'm working on getting letsencrypt certificates into my FreeNAS installation... I can't find anyone who can help me with the last piece, the sqlite command line piece... The reference post is here: