"P Kishor" wrote...
> In any case, for OP's purpose, and esp. since he seems to be inserting
> numbers as strings, as implied by the quoted numbers, he might benefit
> from
>
> CREATE TABLE test (
>  t1 TEXT,
>  t2 TEXT,
>  t3 TEXT,
>  t4 TEXT,
>  PRIMARY KEY(t1, t2)
> );
>
> I don't know if INSERT or REPLACE will work in that case, but seems
> like it should.

Yes, the benefit is great.  Thanks, that works.

josé 

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to