>Yupp, in msql you have to create a sequence on a table and do a select _seq
>from table to get the next value from the sequence. This has the advantage
>that you get a truly ascending sequence of numbers. As far as i know,
>mysqls auto increment fields "reuse" numbers from records that have been
>deleted.
Sorry Greg, but I didn't understand this answer, apart from realising that
what I want to do is possible (ie to turn an empty field in a large table
into an ascending sequence of numbers).
Can you give me concrete examples of how this would be done or point me at
some appropriate documentation please?
Many thanks, and sorry for being so dense.
Chris
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
"Information is not knowledge...." | Chris Stephens
| Humanities Computing Unit
+44 1865 283 295 | OUCS
http://www.hcu.ox.ac.uk/ | Oxford OX2 6NN
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
-------------------------------------------------------------------------
To unsubscribe, go to http://www.Hughes.com.au/extras/email/
This archive was generated by hypermail 2b30 : Mon Mar 04 2002 - 09:03:51 EST