Petite Abeille <petite.abei...@gmail.com> wrote: > create table numbers(num int unique ); > insert into numbers( num ) values( 1 ); > insert into numbers( num ) values( 2 ); > insert into numbers( num ) values( 3 ); > > sqlite> update numbers set num=num+1; > Error: column num is not unique
begin; update numbers set num = -num; update numbers set num = -num + 1; end; -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users