sqlite 表主键自增长

 

ALTER TABLE 旧表名 RENAME TO 新表名

.schema  tablename

CREATE TABLE IF NOT EXISTS "tb_group" (
  "id"  INTEGER PRIMARY KEY AUTOINCREMENT,
  "name" TEXT(255),
  "desc" TEXT(255),
  "sys" TEXT(255),
  "pid" TEXT(255)
);

 
--将一个表(fut_info)中的数据插入到另一个表(fut_info_temp)中。
REPLACE INTO fut_info_temp SELECT * FROM fut_info;
REPLACE INTO fut_info_temp(exchange,code,product) SELECT exchange,code,product FROM fut_info WHERE exchange='CFFEX';
 
--自动创建一个新表(fut_info_t2)，并将老表(fut_info)中的数据插入到新表(fut_info_t2)中。
CREATE TABLE fut_info_t2 AS SELECT * FROM fut_info;