An ID is just an ID. Unique mark in the row. No other meaning. So sanitizing not necessary, AFIK.
On Thu, Aug 8, 2019 at 11:59 AM Jean-Christophe Deschamps <j...@antichoc.net> wrote: > Beware that row id 6655 isn't correct (total_kwh is suddenly decreasing). > This inconsistancy maybe related to row 6654 missing: manipulated data? > So you'd have to sanitize your data first. > > ID TIMESTAMP TOTAL_KWH > 6653 2019-08-06 22:23:26.000 1494.00 > 6655 2019-07-30 22:32:26.000 150.00 <-- > 6656 2019-08-07 18:58:17.000 1673.90 > > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users