MYSQL TABLE CREATION

[Anon]

Can someone give me the mysql command to create a table that has an auto incremented value field and another field with some text in it like a varchar one?

[Anon]

CREATE TABLE test (
id TINYINT NOT NULL AUTO_INCREMENT,
TEXT VARCHAR(128),
UNIQUE ID (id),
PRIMARY KEY(id)
);

Bez wrote:

Can someone give me the mysql command to create a table that has an auto incremented value field and another field with some text in it like a varchar one?

[Anon]

Hi!

Is it true that, if I delete the last row inserted in a table with auto_increment field, the same "number" will be used again?

Is it possible to avoid that?

Greeting,
-sE-