Re: [sqlite] Modify the sqlite database with DB Browser to update a new field

Stairway to Heaven says > a lot about anticipated traffic volume. > > > >-Original Message- > >From: sqlite-users [mailto:sqlite-users- > >boun...@mailinglists.sqlite.org] On Behalf Of Miel Loinaz > >Sent: Saturday, 23 December, 2017 21:34 > >To: sqlite-

Re: [sqlite] Modify the sqlite database with DB Browser to update a new field

lite.org] On Behalf Of Miel Loinaz >Sent: Saturday, 23 December, 2017 21:34 >To: sqlite-users@mailinglists.sqlite.org >Subject: [sqlite] Modify the sqlite database with DB Browser to >update a new field > >Hello, >I want to modify a sqlite database of a weather station software >

Re: [sqlite] Modify the sqlite database with DB Browser to update a new field

First, be careful with modifying a database you don't control. This can result in unexpected results, even if you're tailing onto the end of the table. Some calls are like [select * from ThisTable] and the code itself is expecting exactly the number of fields to be returned. You may also be crea

[sqlite] Modify the sqlite database with DB Browser to update a new field

Hello, I want to modify a sqlite database of a weather station software (wewx.sdb). Date and time are in the form of echo or linux time (field date1). I have added a new field (date2) where I want to display human readable date and time. In Linux console I get it running: UPDATE table1 SET date2