CREATE TABLE "table" (
"id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"col1" BLOB,
"col2" BLOB,
"col3" BLOB,
"coln" BLOB
);
id|col1|col2|col3|coln
1 | 1-1| 1-2| 1-3| 1-n
2 | 2-1| 2-2| 2-3| 2-n
UPDATE table SET col1=?, col2=?, col3=?, coln=? WHERE id=?;
How I can don't change some column under certain conditions via the above SQL statement.
sqlite.
Aucun commentaire:
Enregistrer un commentaire