title: Copying all entries from one table to another with a hard coded value
body: <p>I currently am copying multiple tables from different mysql schemas  into 1 table.  While trying to copy all of the entries, I am having issues with the &quot;Insert&quot; into temp table.</p>
  <p>cua010.doc_table</p>
  <blockquote>
  <p>| ID | _FilePath |</p>
  </blockquote>
  <p>testing.temp_entries</p>
  <blockquote>
  <p>| ID | File | Schema |</p>
  </blockquote>
  <p>Here is my query</p>
  <pre><code>INSERT INTO testing.temp_entries (File, Schema )
  SELECT _FilePath, 'CU010'
  FROM cua010.doc_table
  </code></pre>
  <p>In the end I would like to results to be</p>
  <blockquote>
  <p>| ID | File | Schema |</p>
  <p>| 1  | test | cua010 |</p>
  <p>| 2  | test2| cua010 |...</p>
  </blockquote>
  <p>This is the error message i get</p>
  <blockquote>
  <p>0 84  14:49:47    INSERT INTO testing.temp_entries (File, Schema )
  SELECT _FilePath, 'cua010'
  FROM cua010.doc_table    Error Code: 1064. You have an error in your SQL<br />
  syntax; check the manual that corresponds to your MySQL server version for
  the right syntax to use near 'Schema)
  SELECT _FilePath, 'cua010'
  FROM cua010.doc_table' at line 1   0.031 sec</p>
  </blockquote>