title: SQL: Insert all records from one table to another table without specific the columns
body: <p>I want to insert all the record from the back up table foo_bk into foo table without specific the columns.</p>
  
  <p>if i try this query</p>
  
  <pre><code>INSERT INTO foo 
  SELECT *
  FROM foo_bk
  </code></pre>
  
  <p>i'll get error "Insert Error: Column name or number of supplied values does not match table definition."</p>
  
  <p>Is it possible to do bulk insert from one table to another without supply the column name?
  I've google it but can't seem to find an answer. all the answer require specific the columns.</p>