Re: How to adjust the row id after modifying the tabel

2005-11-21 Thread Michael Stassen
Xiaobo Chen wrote: 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

How to adjust the row id after modifying the tabel

2005-11-21 Thread 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