SQLite Forum

How to not to overwrite a row if the key exists?
Login
This is helpful. In my example code, the only constraint is on the primary key column name.

In this specific case, 

`INSERT or IGNORE INTO x VALUES (...);`

the above should be better than the following?

`REPLACE INTO x VALUES (...) ON CONFLICT DO NOTHING;`
`INSERT or REPLACE INTO x VALUES (...) ON CONFLICT DO NOTHING;`

(At least, the first command is shorter to type:))