05/30/2014 1856 views

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)?

2 Comments   [ + ] Show comments


  • You may want to have support set up a tether and take a look. They should be able to help.
  • While it is possible with an ALTER TABLE command, I would also suggest contacting support.

There are no answers at this time