on 06/23/2004 12:14 AM, Joe Wong at [EMAIL PROTECTED] 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: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED] Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]