How to quickly populate a Sqlite table with an Id field?

Question

SQLite

There is a table in the Sqlite DB

in the 'id' field on all records is 0:



I need to put numbers on each record in the id field in order, by type like this:



I have to manually enter IDs in each record

Is there any command in sqlite , which can do this automatically, that is, so that the numbers in order are recorded automatically by themselves?

Answer 1

https://www.sqlservertutorial.net/sql-server-windo...