Reset user ID number count in database
During some recent experimentation (http://www.itninja.com/question/sql-to-switch-user-ids-part-2) to deal with duplicate user accounts by swapping user IDs, I created an SQL script that changed the ID number in the USER table to 999999999 as a placeholder (i.e. swapping 1111 and 2222: 1111 -> 999999999, 2222 -> 1111, 999999999 -> 2222). This seems to have reset the count somehow, as my import this morning started with ID number 1000000000. Is there a way to set it back to the previous high (in this case, 8200)?
Be the first to answer this question