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: [email protected] Web: http://www.jacobsylvia.com On Mar 6, 2017 6:28 AM, "Clemens Ladisch" <[email protected]> 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 > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
