Adding values into an auto increment field?! how?!

Discussion in 'MySQL' started by redhits, Mar 12, 2010.

0
  1. #1
    How i can add values into an auto increment field?
    i am having a table like

    id: int(5) auto increment
    name: text
    phone: text
    extra: text

    and i need a few more clients :|
     
    redhits, Mar 12, 2010 IP
  2. killaklown

    killaklown Well-Known Member

    Messages:
    2,666
    Likes Received:
    87
    Best Answers:
    0
    Trophy Points:
    165
    #2
    INSERT INTO tablename (name,phone,extra) VALUES('Joe','0981234567','additional info');

    leaving out id will use the next auto increment value.
     
    killaklown, Mar 12, 2010 IP