Listing vacant auto_increment keys

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... ___

Re: mysql in a jail

Jail is a technique available on FreeBSD to have isolated environments running on a common operating system (something similar to virtual machines, but shares memory as main difference). More detailed about this is available at: http://www.freebsd.org/doc/en_US.ISO8859-1/books/arch-handbook/jail.h

Re: Switch replication master

Depending on the size of your databases, it might be a good idea to copy back your 'data' directory from slave to master. I think this should work better, even because the master wouldn't get the INSERT/UPDATEs made on the slave. []s, Conrado - Original Message - From: "Batara Kesuma" <

Re: Switch replication master

and up-to-date. []s, Conrado - Original Message - From: Steve Williams To: cvarda Cc: Batara Kesuma ; [EMAIL PROTECTED] Sent: Tuesday, March 16, 2004 3:28 AM Subject: Re: Switch replication master Hi, Could you take the database down long enough (scheduled downtime) to make the master

Re: How could I do this insert/select?

It seems to work on my MySQL (4.0.18). Tell us which version are you using and the error code/message returned. -- excerpt -- mysql> create table category -> ( -> id tinyint(4) NOT NULL auto_increment, -> name varchar(20) NOT NULL

Blocking INSERT/UPDATE on SLAVE (replication)

Hi there. How could I deny users or applications issuing INSERT or UPDATEs queries on my SLAVE server? This is intended to ensure that slave will not have data which MASTER don't know. Thanks... []s, Conrado -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To uns

Re: Blocking INSERT/UPDATE on SLAVE (replication)

- Original Message - From: "Alan Williamson" <[EMAIL PROTECTED]> To: "cvarda" <[EMAIL PROTECTED]> Sent: Tuesday, March 16, 2004 5:30 PM Subject: Re: Blocking INSERT/UPDATE on SLAVE (replication) > > > cvarda wrote: > > > But this wouldn&#x

Re: Blocking INSERT/UPDATE on SLAVE (replication)

Thank you. I though it could have a way to avoid updates/inserts without touching my 'mysql' database, so it would be a permanent, exact copy of my master server. []s, Conrado - Original Message - From: <[EMAIL PROTECTED]> To: "cvarda" <[EMAIL PROTECTED]&g