Auto Increment for SQLite

[safa-sharpmind]

Auto increment in to available under defaults when creating a table in SQLite database. anyway to add this ?

[Fabio286]

Hi @safa-sharpmind ,

SQLite works different than MySQL/MariaDB.
To have an autoincrement field you have to add an INTEGER PRIMARY KEY to the table.
Here a more detailed explaination

[safa-sharpmind]

Thank you so much, didn't know that :)