lundi 16 mars 2015

How to delete multiple rows with 2 columns as composite primary key in SQLite?

I need to delete some rows in a SQLite table with two columns as primary key, like this:



DELETE FROM apt_lang WHERE (apt_fk, apt_lang_fk) NOT IN ((42122,"en"),(42123,"es"),(42123,"en"))


This works on Oracle and MySQL but not in SQLite.


Can anybody help me?


PS: sorry for my english.


Thanks in advance.


Aucun commentaire:

Enregistrer un commentaire