"RB Smissaert" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Running a query like this: > > delete from sqlite_stat1 > where > not tbl in > ('table1', 'table2', 'table3') > > The strange thing is that rows are deleted where tbl is one of the > listed tables.
Look carefully at the values in the rows that you believe are being deleted inappropriately. Perhaps the value is not precisely 'table1'; for example, may it be that it has trailing spaces, as in 'table1 ', and you just don't notice it when eyeballing the rows? Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users