title: SQL, how to insert all rows of a table into another one
body: <p>OK so I suck at SQL and I always have to ask for help, let me show my problem.
  I have 2 tables, here is the structure for both:</p>
  
  <ul>
  <li><strong>ID</strong> (int) </li>
  <li>courseID (int) </li>
  <li>course (bit) </li>
  <li>bookmark (varchar(100))</li>
  <li>course_date (datetime) </li>
  <li>posttest (bit) </li>
  <li>post_attempts (int)</li>
  </ul>
  
  <p>Now I need to move all rows of one table to the other one (not update), just to have only one table with all rows of both.
  The ID column is a primary key with auto increment, but when I tried to use <code>INSERT INTO table1 SELECT * FROM table2</code>, sql generates this error <strong>#1062 - Duplicate entry '1' for key 'PRIMARY'</strong>.</p>