title: R MySQL to no-default schema
body: <p>I am trying to utilize dbWriteTable to write from R to MySQL.  When I connect to MySQL I created an odbc connection so I can just utilize the command:</p>
  
  <pre><code>abc &lt;- DBI::dbConnect(odbc::odbc(), 
                         dsn = "mysql_conn")
  </code></pre>
  
  <p>In which I can see all my schemas for the MySQL instance.  This is great when I want to read in data such as:</p>
  
  <pre><code>test_query &lt;- dbSendQuery(abc, "SELECT * FROM test_schema.test_file")
  test_query &lt;- dbFetch(test_query)
  </code></pre>
  
  <p>The problem I have is when I want to create a new table in one of the schema's how to declare the schema I want to write to in</p>
  
  <pre><code>dbWriteTable(abc, value = new_file, name = "new_file", overwrite=T)
  </code></pre>
  
  <p>I imagine I have to define the test_schema in the dbWriteTable portion but haven't been able to get it to work.  Thoughts?</p>