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?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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