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