Results 1 to 3 of 3

Thread: Moving IDs in SQL

  1. #1

    Moving IDs in SQL

    After searching google and forums I cant find this solution.

    I want to insert an Id where one exists but instead of swapping its going to have to ++ to the rest of the ids in front of it? I'm assuming this will be done with a loop? Or because its auto increment it will automatically know to move everything up?

  2. #2
    yea you can't really do that, you can do one of two things... 1) drop the table and recreate it each time w/ the new IDs or 2) create a secondary column and use that as an the "ID" column
    Let us live so that when we come to die even the undertaker will be sorry. - Mark Twain
    Don't PM me your CSS, xHTML, JS or PHP questions. I will not reply to ANY IE6 questions.

  3. #3
    Something like this should work:
    Code:
    UPDATE table SET id=id+1 WHERE id>=yourID
    INSERT INTO table (id, yourothercolumns) VALUES(yourID, yourOtherData)
    ALTER TABLE table AUTO_INCREMENT=AUTO_INCREMENT+1

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Home About kirupa.com Meet the Moderators Advertise

 Link to Us

 Credits

Copyright 1999 - 2012