| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Ben Kirkpatrick | Date: | April 23 1999 10:09pm |
| Subject: | AUTO_INCREMENT Limit? | ||
| View as plain text | |||
I'm using mysql Ver 9.15 Distrib 3.21.30, for sun-solaris2.6 (sparc) which doesn't seem to support "OPTIMIZE TABLE". I created 65k some-odd records (ran out of keys), then deleted the lowest 200 records. I ran "isamchk" and then tried doing more inserts, but I get this: mysql> INSERT INTO testauto VALUES (0,'test'); ERROR 1062: Duplicate entry '65535' for key 1 I must be missing something that gets this to re-use the unused keys. Thanks, Hiding in the light, --Ben, http://www.pdx.net/~ben
| Thread | ||
|---|---|---|
| • AUTO_INCREMENT Limit? | Ben Kirkpatrick | 24 Apr |
| • Re: AUTO_INCREMENT Limit? | Paul DuBois | 24 Apr |
| • I can't shut down mySQL. | Daevid Vincent | 24 Apr |
| • Re: I can't shut down mySQL. | Paul DuBois | 24 Apr |
| • this list | taubin | 24 Apr |
| • Re: this list | Fred Read | 26 Apr |
| • Re: I can't shut down mySQL. | Daevid Vincent | 26 Apr |
| • Re: I can't shut down mySQL. | Michael Widenius | 27 Apr |
| • Re: I can't shut down mySQL. | Sasha Pachev | 27 Apr |
| • Re: AUTO_INCREMENT Limit? | Thimble Smith | 24 Apr |
