title: create table with auto increment as first col and data type as second
body: <p>maybe I am over thinking this these are the instructions</p>
  
  <p>create four new tables: my_interests, my_professions, my_seeking and my_status. These tables should contain two columns: one for an id and another for the data value. Populate these from the appropriate columns in the my_contacts table. Once your new tables are ready, you can replace the original data columns with id numbers matching the applicable id values in your new my_professions and my_status tables.</p>
  
  <p>SO THE WAY I READ THE FIRST IS I HAVE THE FIRST COL AS AN AUTO INCREMENT PRIMARY KEY, THE NEXT VALUE WOULD BE THE DATA TYPE, I AM STARTING WITH MY_STATUS FIRST AND THE TYPES WOULD BE </p>
  
  <p>COMMITED_RELATIONSHIP</p>
  
  <p>DIVORCED</p>
  
  <p>MARRIED</p>
  
  <p>SINGLE</p>
  
  <p>WIDOWED</p>
  
  <p>AND MY AUTO_INC NUMBER WOULD CORRESPOND TO THE ID OF DATA, IN OTHER WORDS</p>
  
  <p>01**COMMITED</p>
  
  <p>02**DIVORCED</p>
  
  <p>03** AND SO ON</p>
  
  <p>AM I CORRECT IN THE WAY I AM READING THE INSTRUCTIONS? 
  AND IF SO NOT QUITE SURE HOW TO DO THIS, I KNOW HOW TO CREATE THE TABLE, AND I UNDERSTAND INSERT INTO AND VALUES, BUT HOW DO I INSERT THE VALUES AND AUTO INCREMENT? I REALLY DISLIKE PROGRAMMING :(</p>
  
  <p>thanks in advance</p>