What is the purpose of the Navicat for SQLite table option

A set of powerful and comprehensive sqlite graphical user interface tools, Navicat forSQLite provides users with a full set of server management functions. It is equipped with SQL query, data editing and data Model tools, and supports all SQLite object types. But some users don't know much about their functionality. This tutorial will give you a detailed introduction to the Navicat for SQLite table options What is the role?

Original: http://www.formysql.com/wenti/SQLite-biaoxuanxiang.html

Navicat for SQLite

Primary KEY on CONFLICT: Specifies that an algorithm resolves primary key restriction conflicts.

ROLLBACK: When a throttling conflict occurs, roll back immediately, end the current transaction, and abort the command plus the Sqlite_constraint return code. If there is no transaction, the algorithm is the same as ABORT.

Abort: When a constraint conflict occurs, discard the changes made before and abort the return code with Sqlite_constraint. However, no rollback is run, so the changes made by the previous command are saved, which is the default performance.

FAIL: When a constraint conflict occurs, the command aborts with the return code of Sqlite_constraint, but the previous changes are saved and not discarded. For example, if the UPDATE statement encounters a constraint violation on the 100th line that it is trying to update, the first 99 rows change to save but row 100 and subsequent changes do not occur.

IGNORE: When a constraint violation occurs, the row containing the constraint violation is not inserted or updated, but the command continues to function correctly. Other rows continue to be inserted or updated normally. When you use the IGNORE Conflict resolution algorithm, no error is returned.

REPLACE: When a UNIQUE constraint violation occurs, the current row is inserted or updated, leading to a constraint violation being removed. command to continue to run normally after the substitution. The REPLACE conflict resolution algorithm does not return an error. If a NOT null restriction conflict occurs, the null value is superseded by the default value of the column. If the column does not have a default value, use the ABORT algorithm. If a CHECK restriction violation occurs, the IGNORE algorithm is used.

Auto-increment: Sets or resets the value automatically incremented in the edit field to indicate the value of the next record.

Without ROWID: Ignore ROWID (and "oid", "_rowid_"), support SQLite 3.8.2 or later.

The above is an introduction to the ' Navicat for SQLite table Options ', and if not, you can click on Navicat to download the app.

What is the purpose of the Navicat for SQLite table option