ID列一定要为自增
以前ID列不是自增,改成自增的步骤:
--1.将表名改为临时表
ALTER TABLE "Student" RENAME TO "_Student_old_20140409"
--2.创建新表
CREATE TABLE "Student" (
"Id" INTEGER PRIMARY KEY AUTOINCREMENT,
"Name" Text)
--3.导入数据
INSERT INTO "Student" ("Id", "Name") SELECT "Id", "Title" FROM "_Student_old_20140409";
INSERT INTO student VALUES(null, ‘aaa‘)--自增列 值 为null
原文:https://www.cnblogs.com/tulater/p/12400504.html