Insert If Not Exists SQLite

[GhostXoP]

Is this possible? INSERT INTO ?? IF NOT EXISTS ?? (?,?) or INSERT INTO ?? (?,?) IF NOT EXISTS ?? or IF NOT EXISTS ?? INSERT INTO ?? (?,?)

[Cadu12]

First, use SELECT, if returns 0 or doesnt exists, then use INSERT INTO

[Castillo]

No, if I'm right that does not exist, maybe this:

INSERT OR IGNORE INTO 

[GhostXoP]

What about insert or update?

[Castillo]

Not sure if that exists.

[GhostXoP]

So insert or ignore should work? it inserts just like insert if not exist?

[Castillo]

I think so, I never used it though.