SQLite program inserts a flag field to obtain a new ID

The syntax of SQLite differs from that of SQL Server. For example, to insert data, the field indicating the seed must be specified as null to obtain a new ID.

Select   @ Identity   [ ID ]

But not in SQLite,

Insert   Into T_1 (ID, name) Values ( Null , ' Zhao yukai 5 ' );
Select Last_insert_rowid () Newid ;

Note that the function for obtaining the new ID is last_insert_rowid () instead of last_insert_id (). The last_insert_id () function is the function for MySQL to obtain the newly inserted auto-incrementing primary key. What's more strange about SQLite is that for auto-increment numeric primary keys, the value must be null.

Finally, we recommend the SQLite development tool http://sqliteadmin.orbmu2k.de/