How to create an AUTOINCREMENT field in SQLite?

The user has to declare an INTEGER PRIMARY KEY column on the table at first. After this, whenever we insert a NULL into that column of the table, it will automatically be converted into an integer which is one greater than the most considerable value of that column over all the other rows present in the table.

Suggest An Answer

No suggestions avaliable!

Latest post from SQLite Interview Questions

Ask Question