1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

add unique ID for each record the quick way

Discussion in 'MySQL' started by TriG0rZ, Nov 13, 2008.

  1. TriG0rZ

    TriG0rZ New Member

    Joined:
    Oct 2, 2008
    Messages:
    88
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    UK
    Ok i have a database with records and i have to add a unique ID for each database i can take the long way and do update .... set ...=1 and so on, BUT is their a faster way of doing it so, like i do a sql statment and it does it for all records??

    Thank you very much.
     
  2. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,276
    Likes Received:
    364
    Trophy Points:
    83
    Add a unique auto increment field
     
  3. TriG0rZ

    TriG0rZ New Member

    Joined:
    Oct 2, 2008
    Messages:
    88
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    UK
    awesome that has given me the step i needed thank you very much :D!
     

Share This Page