Hi there.

I've a table with an auto_increment primary key. I want
to reuse keys (index numbers) that becomes vacant when
I delete entries.

How do I list the vacant keys from a table?

Example table:
1
2
5
6
9
10 <= max value, next is 11.

List of vacant keys:
3
4
7
8

Thanks...

 
__________________________________________________________________________
Acabe com aquelas janelinhas que pulam na sua tela.
AntiPop-up UOL - É grátis!
http://antipopup.uol.com.br/



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to