title: What does "ADD AUTO_INCREMENT value" mean in phpMyAdmin
body: <p>In <code>phpMyAdmin</code>, I wanted to copy a database to another name so I would effectively have 2 databases exactly the same. One as my oringinal and another for testing on the staging website site that I have. </p>
  
  <p>There are three main options</p>
  
  <pre><code>structure only
  structure and data
  data only,
  </code></pre>
  
  <p>I need structure and data, however there are more checkbox options below;</p>
  
  <pre><code> CREATE DATABASE before copying  //was checked by default
   Add DROP TABLE / DROP VIEW
   Add AUTO_INCREMENT value //was checked by default
   Add constraints
   Switch to copied database 
  </code></pre>
  
  <p>What does "ADD AUTO_INCREMENT value" and "Add constraints" mean and if I copy structure and data doesnt any fields with AI get copied?</p>