Re: sequence table: Definitive answer please!

[Paul DuBois]

At 8:20 PM -0500 2000-01-03, Bob Strouper wrote:
>  >There are two (common) methods with MySQL to get a
>>unique id - and you have mixed both.
>
>looks like I have to use id+1 on both a column with auto
>increment and one without :-/

No, you'd use one or the other.




>But I am now even more confused as to why I still have to use
>the id+1 with the auto incrementing column type.

You don't.  It's used only with non-AUTO_INCREMENT columns.


-- 
Paul DuBois, paul@stripped