title: Introduction of SQL SELECT ... INTO - Why will it not run?
body: <p>I'm running a SQL server and need to run some commands using the <code>SELECT ... INTO</code> commands. At the moment (as a test) I am running this command:</p>
  
  <pre><code>SELECT * 
  INTO `assets_copy` 
  FROM `assets`
  </code></pre>
  
  <p>The simplest example possible, and yet it still won't run. I get the error:</p>
  
  <pre><code>MySQL said:  
  
  #1064 - You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'assets_copy` FROM `assets`  LIMIT 0, 30' at line 1 
  </code></pre>
  
  <p>So I'm wondering if the version of SQL I'm using doesn't support this?  I'm using 3.23.49 of MySQL.</p>