[web2py] change id?

2012-12-19 Thread Aurelijus Useckas
is it possible to change row id or null it so it starts sequential counting starting from 0? thank you --

Re: [web2py] change id?

2012-12-19 Thread Vinicius Assef
I think it depends on you RDBMS. On Wed, Dec 19, 2012 at 10:00 AM, Aurelijus Useckas aurelijus.usec...@gmail.com wrote: is it possible to change row id or null it so it starts sequential counting starting from 0? thank you -- --

Re: [web2py] change id?

2012-12-19 Thread Aurelijus Useckas
I''m using an SQlite btw. autoincrement resets with this command: print db.executesql('UPDATE SQLITE_SEQUENCE SET seq = 0 WHERE name = \'auth_user\'') On Wednesday, December 19, 2012 2:20:49 PM UTC+2, viniciusban wrote: I think it depends on you RDBMS. On Wed, Dec 19, 2012 at 10:00 AM,