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 <[email protected]> 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 [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
