> Does anyone know if there is a way of setting an auto numbered field > that starts at say 2,000,000 and decreases by one on each insert?
Well, if you know the starting number you can use a normal autoinc field and retrieve the value you want by substracting: 2,000,000 - AutoIncField Regards -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
