Re: Auto decrement

2003-05-27 Thread Román Sánchez 
> 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]

Auto decrement

2003-05-27 Thread Gary Broughton 
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]