SQLite Forum

How to not to overwrite a row if the key exists?
Login
This becomes confusing.

"INSERT or IGNORE INTO" is on the diagram at the top of the following webpage. But I don't see it is explained in the text on that webpage. What does it mean?

https://www.sqlite.org/lang_insert.html

I don't want to insert a record if the name of the try-to-be-inserted record exists and insert the record if the try-to-be-inserted record does not exist. Is `INSERT or IGNORE INTO x VALUES (...);` the best to use for this case? Thanks.