Hi all, Now I see the what's happening. But what if I need to create a table with two primary keys and one auto incremented (and I DO need that!)? Isn't this possible?
Thanks a lot Trevor and all. Thanks for the attention. Best regards, Bruno On 6/28/07, Trevor Talbot <[EMAIL PROTECTED]> wrote:
> To add the guarantee that automatically generated values will never be > reused, your only option is: > > create table foo(id integer primary key autoincrement); Got involved testing this and forgot what I originally went to look for. You can add "not null" on the end of that, if you want. It's already implicitly not null, but it's still valid syntax and will work as intended. "integer primary key autoincrement" is the magical phrase that must not be broken up. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
-- /** * Bruno Silva de Oliveira * Bacharel em Ciência da Computação * Mestrando em Inteligência Computacional * http://www.inf.ufpr.br/brunoso/ * * http://www.last.fm/user/bsoliveira/ */