That did the trick. THANKS and Happy New Year! On Jan 1, 2010, at 4:00 PM, Igor Tandetnik wrote:
> Chris Vadnais wrote: >> Is there a way to set the values in a given column to a series of sequential >> numbers? >> >> For example, I have a Column called "qid" and 1002 rows. I would like to >> tell SQL to set the values in "qid" to 1, 2, 3, 4, etc. >> all the way down to 1002. > > update mytable set qid = > (select count(*) from mytable t2 where t2.rowid <= mytable.rowid); > > Igor Tandetnik > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
