vendredi 14 août 2015

how to make non primary key column is auto incremented

i am using sqlite with java JDBC, and i created the following table:

private final String sqlTableNode = "CREATE TABLE "+this.TABLE_NODE+
        " ( "+this.NODE_TABLE_PK_COL+" INTEGER, " +
        this.NODE_TABLE_NODE_ID_COL+" TEXT NOT NULL, " +
        this.NODE_TABLE_LAT_COL+" TEXT NOT NULL, " +
        this.NODE_TABLE_LNG_COL+" TEXT NOT NULL, " +
        "PRIMARY KEY ("+this.NODE_TABLE_LAT_COL+", "+this.NODE_TABLE_LNG_COL+") );";

my question is, how can i make the first column "this.NODE_TABLE_PK_COL" is auto incremented while it is not a primary key??

Aucun commentaire:

Enregistrer un commentaire