List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:May 30 1999 5:57pm
Subject:Re: mysql
View as plain text  
At 5:46 PM +0100 5/30/1999, lee@stripped wrote:
>Hi,
>
>I seem to have reached a limit of 256 when using the last_insert_id()
>function
>- is there any way around this ?
>
>Would it be simpler to create a unique id table and update that after
>each insert?

You don't show your table structure, but I'll bet your column is declared
as a TINYINT, in which case it can only hold 256 distinct values.
Use a larger integer type to get a larger range.

--
Paul DuBois, paul@stripped
Northern League Chronicles: http://www.snake.net/nl/
Thread
mysqllee30 May
  • Re: mysqlJim Faucette30 May
  • Re: mysqlPaul DuBois30 May