[SOLVED] Consecutive id

[gevo12321]

hi

 

lets say i made a column in mysql for id numbers

 

is there a way where it will automatically give me the next integer for an id every time i insert a new row?

 

thank you

[bubblegum.anarchy]

Define the id as an auto_increment

 

CREATE TABLE repository (
     id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'unique record identifier',
     value TEXT NULL DEFAULT NULL COMMENT 'repository value',
     primary_key (id)
);

[gevo12321]

thank you very much