title: How to write entire dataframe into mySql table in R
body: <p>I have a data frame containing columns 'Quarter' having values like "16/17 Q1", "16/17 Q2"... and 'Vendor' having values like "a", "b"...  .</p>
  
  <p>I am trying to write this data frame into database using</p>
  
  <pre><code>query &lt;- paste("INSERT INTO cc_demo (Quarter,Vendor) VALUES(dd$FY_QUARTER,dd$VENDOR.x)")
  </code></pre>
  
  <p>but it is throwing error :</p>
  
  <pre><code>Error in .local(conn, statement, ...) : 
  </code></pre>
  
  <p>could not run statement: Unknown column 'dd$FY_QUARTER' in 'field list'</p>
  
  <p>I am new to Rmysql, Please provide me some solution to write entire dataframe?  </p>