要想将所有表的自增列都归零，直接清空sqlite_sequence表就可以了：
DELETE FROM sqlite_sequence;
Q.E.D.
SQLite 将所有表的自增列清零
2020-07-01 650 次阅读
No PAINS No GAINS.
Hello, World!
No PAINS No GAINS.
No PAINS No GAINS.
2020-07-01 650 次阅读
要想将所有表的自增列都归零，直接清空sqlite_sequence表就可以了：
DELETE FROM sqlite_sequence;
Q.E.D.
No PAINS No GAINS.
Comments | 0 条评论