How can I create a sequence in SQLite?

Question

I have create a table in sqlite. there is two fields pk_categoryid,category_name. I want to enter only one value from user side. so how can I create sequence

Answer 1

If you mean that you want the primary key to be autogenerated, then look at AUTOINCREMENT when creating your table:

• SQLite CREATE TABLE syntax.

Answer 2

create table Categories (pk_categoryid integer primary key autoincrement, category_name text);