Answers.Body: <p>This is more of mysql than CiviCRM. You will need to reset the AUTO_INCREMENT value for that table.</p>
  
  <pre><code>ALTER TABLE civicrm_membership AUTO_INCREMENT= 10001
  </code></pre>
  
  <p>Thanks
  Pradeep</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-02-08T16:25:26.433Z
Answers.LastActivityDate: 2019-02-08T16:25:26.433Z
Answers.UserDisplayName: Pradeep Nayak
Body: <p>I have an external identifier which has been imported and its max value is 10000,<br> whereas it needs to be used as membership id, but membership id <br>max value is 1500.Now to keep the Id of the membership consistent with <br>external identifier, I want to start next membership id as 10001 <br>instead of 15001.
  Is there a way to incrememt the membership id from 1500 to 10000 in database?</p>
  
Tags: <civimember>
Title: How can I alter next value of membership id (which would be auto incremented)?
ThreadText: # How can I alter next value of membership id (which would be auto incremented)?
  
  (Asked by: username_0 on 2019-02-08)
  
  I have an external identifier which has been imported and its max value is 10000,  
   whereas it needs to be used as membership id, but membership id   
  max value is 1500.Now to keep the Id of the membership consistent with   
  external identifier, I want to start next membership id as 10001   
  instead of 15001.
  Is there a way to incrememt the membership id from 1500 to 10000 in database?
  
  **Tags:** civimember
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2019-02-08. Score: 5 | Accepted answer
  
  This is more of mysql than CiviCRM. You will need to reset the AUTO_INCREMENT value for that table.
  ALTER TABLE civicrm_membership AUTO_INCREMENT= 10001
  
  Thanks
  Pradeep
  
  
  ---
  
  