From: Chris W. Date: October 4 1999 4:03am Subject: MYSQL and auto reindexing List-Archive: http://lists.mysql.com/mysql/15009 Message-Id: <021801bf0e1d$77e94540$34b3e6cd@perfekt.net> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0215_01BF0DFB.F0A327C0" ------=_NextPart_000_0215_01BF0DFB.F0A327C0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello, I have a little problem, I created a database and I have = auto_increment on, after a while I removed a lot of entries from the = database and optimized it to get rid of the empty spaces left after the = deleted records, but now my question is: Is there a way to do some = reindexing on the table to get the auto_increment sorted out? Like to = get the first column in order sorted 1 then next record 2 and so on = until it reaches the end of last record so it is fairly sorted out? = Thank you. Chris ------=_NextPart_000_0215_01BF0DFB.F0A327C0--