Antonio Bassinger wrote:
Hi All!
I've a MySQL table:
table (id INT NOT NULL AUTO_INCREMENT,
flag TINYINT NOT NULL,
msgID VARCHAR(30) NOT NULL,
msgName VARCHAR(30),
size INT NOT NULL,
PRIMARY KEY(id));
If I delete a row, say 5th, the id entries are 1 2 3 4 6 7 ... 10.
I wish to keep entries consecutive, that is rearrange the table as 1 2 3
4 5
6 ... 9. How do I go about it?
Read this thread:
http://marc.theaimsgroup.com/?l=php-general&m=114656385709968&w=2
It will tell you this is a really bad idea.
--
Postgresql & php tutorials
http://www.designmagick.com/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
