Make an autoincrement field in SQLite

Question

I've got a table in SQLite

create table table_dishes (_id integer primary key autoincrement, 
    title text,
    price real,
    weight real,
    description text,
    position integer);

How to make field "position integer" autoincrement?

why you need this?you can think position value is _id value or if you want not equal you can see that like _id + 1 — MHP, Aug 19 '14 at 18:40

score 1 · Answer 1 · answered Aug 19 '14 at 18:31

There is as such no autoincrement feature but they have added ROWID which is added automatically. So the integer primary key which you will create for your table will point to this ROWID.

Also from the SQLITE docs:

A column declared INTEGER PRIMARY KEY will autoincrement.

score 0 · Answer 2 · answered Aug 19 '14 at 18:33

0

Per the SQLite documentation here,

Short answer: A column declared INTEGER PRIMARY KEY will autoincrement

answered Aug 19 '14 at 18:33

Alexander Lucas

22,171
3
46
43

user3487063 · Answer 3 · 2014-08-19T18:38:47.563

0

insert value should be like : (SELECT IFNULL(MAX(position), 0) + 1 FROM table_dishes) for that column, every time you insert a new row into table_dishes table, if you decide to keep position column as non-primary key

edited Aug 19 '14 at 18:38

answered Aug 19 '14 at 18:33

user3487063

3,672
1
17
24

Make an autoincrement field in SQLite

3 Answers3