From sql shell (from a file works the same way):
asql> create temp table test (a text);
asql> insert into test values('a
...> b
...> c
...> d');
rows inserted
-------------
1
asql> select * from test;
a
--------------
a
b
c
d
-----Ursprüngliche Nachricht-----
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 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 D. Sylvia
Jake Sylvia's Consulting
430 Cole St.
Seekonk, MA 02771
Cell: (508) - 954 - 2536
EMail: jacob.syl...@gmail.com
Web: http://www.jacobsylvia.com
On Mar 6, 2017 6:28 AM, "Clemens Ladisch" <clem...@ladisch.de> wrote:
> 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 value(s), and how to identify the row(s) to update.
>
>
> Regards,
> Clemens
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
___________________________________________
Gunter Hick
Software Engineer
Scientific Games International GmbH
FN 157284 a, HG Wien
Klitschgasse 2-4, A-1130 Vienna, Austria
Tel: +43 1 80100 0
E-Mail: h...@scigames.at
This communication (including any attachments) is intended for the use of the
intended recipient(s) only and may contain information that is confidential,
privileged or legally protected. Any unauthorized use or dissemination of this
communication is strictly prohibited. If you have received this communication
in error, please immediately notify the sender by return e-mail message and
delete all copies of the original communication. Thank you for your cooperation.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
