title: fail to move data from one table to another in sql
body: <p>The structure and data types are all the same, but can't move data between tables in the same database..
  I have 2 tables tempo_sales and sales</p>
  
  <pre><code>mysql_query("insert into sales select * from tempo_sales");
  </code></pre>
  
  <p>The same program algorithm works with other database, but with the current database m working with, t seems impossible  to get  through</p>