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
·
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
.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
&
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 -
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
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
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
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
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
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
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
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
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
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
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:
15 matches
Mail list logo