自动递增不是Android的SQLite数据库工作 [英] Auto Increment not working in android SQLite Database

问题描述

我有一个运行的数据库，但主键将不会自动递增。有谁知道这个问题可能是什么？

在code是如下

  //数据库名称和版本
私有静态最后弦乐DATABASE_NAME =kmky_database.db;
私有静态最终诠释DATABASE_VERSION = 1;//数据库表
私有静态最后弦乐TABLE_NAME =日志;
私有静态最后弦乐COLUMN_ID =_id;
私有静态最后弦乐COLUMN_PHONENUMBER =PHONENUMBER;
私有静态最后弦乐COLUMN_TYPE =类型;
私有静态最后弦乐COLUMN_DATE =时间戳;
私有静态最后弦乐COLUMN_INCOMING =进入;
私有静态最后弦乐COLUMN_OUTGOING =离开;
私有静态最后弦乐DATABASE_CREATE =CREATE TABLE+ TABLE_NAME +（+ COLUMN_ID +INTEGER PRIMARY KEY，+ COLUMN_PHONENUMBER +TEXT+ COLUMN_TYPE +TEXT+ COLUMN_DATE +INTEGER，+ COLUMN_INCOMING + INTEGER，+ COLUMN_OUTGOING +INTEGER）;;
 

解决方案

您必须创建主键，因为这

  ......（+ COLUMN_ID +INTEGER PRIMARY KEY AUTOINCREMENT .....
 

您忘了 AUTOINCREMENT 键字多数民众赞成。

I've got a running database but the primary key won't auto increment. Does anyone know what the problem could be?

The code is as following

    // Database name and Version
private static final String DATABASE_NAME = "kmky_database.db";
private static final int DATABASE_VERSION = 1;

// Database Table
private static final String TABLE_NAME = "logs";
private static final String COLUMN_ID = "_id";
private static final String COLUMN_PHONENUMBER = "phonenumber";
private static final String COLUMN_TYPE = "type";
private static final String COLUMN_DATE = "timestamp";
private static final String COLUMN_INCOMING = "incoming";
private static final String COLUMN_OUTGOING = "outgoing";
private static final String DATABASE_CREATE = "CREATE TABLE " + TABLE_NAME + "(" + COLUMN_ID + " INTEGER PRIMARY KEY, " + COLUMN_PHONENUMBER + " TEXT, " + COLUMN_TYPE + " TEXT, " + COLUMN_DATE + " INTEGER, " + COLUMN_INCOMING + " INTEGER, " + COLUMN_OUTGOING + " INTEGER);";

解决方案

You have to create the Primary key as this

  ...."(" + COLUMN_ID + "  INTEGER PRIMARY KEY AUTOINCREMENT.....

You forgot the AUTOINCREMENT key word thats all.

这篇关于自动递增不是Android的SQLite数据库工作的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！