automatic id attribute

[dadamssg]

Im pretty sure theres someway that mysql can add a ID number to a row everytime one is created. How do that? and i will be deleting and adding rows of data and i want each row to still have that unique ID number. Like if mysql has something where it numbers every data row, i don't want all the numbers to move down one if i delete a row, i want them to remain that same ID number...thanks in advance

[trq]

CREATE TABLE foo (
  id INT NOT NULL AUTO_INCREMENT,
  #
  # more field definitions.
  #   
  PRIMARY KEY (id)
);