Sqlite创建自增字段,代码如下:
CREATE TABLE [push_widget] ( [_id] INTEGER PRIMARY KEY AUTOINCREMENT, [push_id] VARCHAR(50) NOT NULL, [type] INT(10) NOT NULL DEFAULT (0), [url] VARCHAR, [pic_url] VARCHAR, [short] VARCHAR, [author] CHAR, [push_type] INT NOT NULL DEFAULT (0), [time] TIMESTAMP, [score] FLOAT DEFAULT (0));
转载于:https://www.cnblogs.com/lslzmx/archive/2013/05/28/3103804.html