the following is
sqlite> Create table test (t1 primary key, t2 secundary key, t3, t4);
sqlite> INSERT or REPLACE into test values ('1','2','3','4');
sqlite> select * from test;
1|2|3|4
sqlite> INSERT or REPLACE into test values ('1','2','3','5');
sqlite> select * from test;
1|2|3|5
sqlite> INSERT or REPLACE into test values ('1','2','4','5');
sqlite> select * from test;
1|2|4|5
sqlite> INSERT or REPLACE into test values ('1','3','3','5');
sqlite> select * from test;
1|3|3|5
sqlite>
this last one should have kept the 1,2,4,5 entries and added a new one.
What I want is to be able to update and replace t3 and t4 if the first two
values are the same. If the first two values differ, then I want to add
that one. By the way, I also tried unique and it does the same thing.
Using SQLite version 3.6.11.
Any help would be greatly appreciated.
thanks,
josé
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
