List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:January 4 2000 2:55am
Subject:Re: sequence table: Definitive answer please!
View as plain text  
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
Thread
sequence table: Definitive answer please!Bob Strouper4 Jan
  • Re: sequence table: Definitive answer please!Paul DuBois4 Jan
    • Re: sequence table: Definitive answer please!Paul DuBois4 Jan
  • Re: sequence table: Definitive answer please!Tonu Samuel4 Jan
    • Re: sequence table: Definitive answer please!Benjamin Pflugmann4 Jan
  • Re: sequence table: Definitive answer please!Benjamin Pflugmann4 Jan
  • Re: sequence table: Definitive answer please!hypnos4 Jan
Re: sequence table: Definitive answer please!Bob Strouper4 Jan
  • Re: sequence table: Definitive answer please!Paul DuBois4 Jan
  • Re: sequence table: Definitive answer please!Benjamin Pflugmann4 Jan
Re: sequence table: Definitive answer please!Benjamin Pflugmann4 Jan
Re: sequence table: Definitive answer please!Bob Strouper4 Jan
  • Re: sequence table: Definitive answer please!Benjamin Pflugmann4 Jan
Re: sequence table: Definitive answer please!Bob Strouper4 Jan