title: Cross MySQL Database Same Machine INSRET SYNTAX Fail
body: <p>i have working to migrate the different mysql database in the same machine. I want to copy all the rows in table called ms_barang from fist database to another database.</p>
  
  <p>The columns is little bit different so, i create join table and inserting to second table in different database.</p>
  
  <p>My SQL Syntax is</p>
  
  <pre><code> INSERT INTO sre.`ms_barang`(`idms_kodebarang`,`nama`,`gudang`,`jenis`,`packing`) 
   VALUES (
       SELECT sr.mb.`idms_kodebarang` AS 'idms_kodebarang', sr.mb.`nama` AS 'nama', sr.mb.`gudang` AS 'gudang', sr.mb.`jenis` AS 'jenis', sr.md.`packing` 'packing'
       FROM sr.ms_barangjadi mb JOIN sr.ms_daftarbarang md
       WHERE sr.mb.`idms_kodebarang` = sr.md.`idms_kodebarang`
    );
  </code></pre>
  
  <p>as you can see, there are two database called SR and SRE</p>
  
  <p>but it keeps telling that the syntax is fail. where is the error?</p>