Re: question on auto increment field

[Scott Haneda]

on 06/23/2004 12:14 AM, Joe Wong at joewong@stripped wrote:

>   If it possible to limit the max value of an auto increment field to say,
> 9999,9999 and how to do it? I am using MySQL 4.0.18.

I am not sure, as a 'hack' you could simply insert a blank record with the
value set to 9999,9999, once you reach that limit and try to insert a
record, a error would be generated, no new records would be able to be
inserted until this was resolved.
-- 
-------------------------------------------------------------
Scott Haneda                                Tel: [phone]
http://www.newgeo.com                       Fax: [phone]
scott@stripped                            Novato, CA U.S.A.