Gossamer Forum
Quote Reply
autoincrement by 7 ?
I see how to setup an autoincrement field.

I am migrating a database that has membership numbers already assigned. The previous system incremented them by 7, of all things, and I'm being asked to maintain that system.

Avoiding all the political or design ramifications, my simple question: can I get the system to increment the number by 7 each time a new User is created, and if so, how?

Alan Frayer
Don't just read the news - make the news!
Your World News - http://yourworldnews.frayernet.com
Quote Reply
Re: [afrayer] autoincrement by 7 ? In reply to
Hi,

I don't think so on MySQL, but you could with Postgres or Oracle. It would involve manually removing the sequence in sql, and creating a new sequence that increments by 7 instead of 1.

Cheers,

Alex
--
Gossamer Threads Inc.