How to adjust the row id after modifying the tabel

[Xiaobo Chen]

Hi, all

I follow the example:

CREATE TABLE animals (
     id MEDIUMINT NOT NULL AUTO_INCREMENT,
     name CHAR(30) NOT NULL,
     PRIMARY KEY (id)
 );

INSERT INTO animals (name) VALUES
    ('dog'),('cat'),('penguin'),
    ('lax'),('whale'),('ostrich');

SELECT * FROM animals;

The thing is that after delete one of them like this:

delete from animals where id=4;

how can I have the 'id' to be continuous. Now it will be like:

1
2
3
5
6

Or shall I create the table differently at first? If so, how?

Thanks for your help in advance.

Xiaobo





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