There is no unique constraint (express or implied) in your schema, therefore no conflict occurs and it is possible to insert as many identical rows as your diskspace will hold.
-----Urspr?ngliche Nachricht----- Von: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-bounces at mailinglists.sqlite.org] Im Auftrag von Tilsley, Jerry M. Gesendet: Mittwoch, 09. M?rz 2016 16:03 An: sqlite-users at mailinglists.sqlite.org Betreff: [sqlite] Insert or Replace Trouble All, I'm trying to use the INSERT OR REPLACE syntax so that I don't have to worry about duplicate entries without creating a trigger. Using the schema: CREATE TABLE messages (id numeric); and using the SQL: insert or replace into messages values (1); Why does this result in multiple rows of the same value? I'm I just not understanding the syntax correctly? Thanks, Jerry Tilsley, CIS Lvl 2 Information Services | St. Claire Regional Medical Center Jerry.Tilsley at st-claire.org ________________________________ Disclaimer**** This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of St. Claire Regional Medical Center. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing or copying of the email is strictly prohibited. If you received this email in error please notify the St. Claire Regional Helpdesk by telephone at 606-783-6565. _______________________________________________ sqlite-users mailing list sqlite-users at mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users ___________________________________________ Gunter Hick Software Engineer Scientific Games International GmbH FN 157284 a, HG Wien Klitschgasse 2-4, A-1130 Vienna, Austria Tel: +43 1 80100 0 E-Mail: hick at scigames.at This communication (including any attachments) is intended for the use of the intended recipient(s) only and may contain information that is confidential, privileged or legally protected. Any unauthorized use or dissemination of this communication is strictly prohibited. If you have received this communication in error, please immediately notify the sender by return e-mail message and delete all copies of the original communication. Thank you for your cooperation.