title: How to do dbGetQuery for loop in R
body: <p>i have three variables a,b,c (Actually more than 300 variables in my case)</p>
  
  <pre><code>t&lt;-c(a,b,d)
  
  a&lt;-dbGetQuery(con, "SELECT * FROM a")
  b&lt;-dbGetQuery(con, "SELECT * FROM b")
  d&lt;-dbGetQuery(con, "SELECT * FROM d")
  </code></pre>
  
  <p>How can I make a loop to request data from MySQL in R? The existing question does not have the explanation on how to write it into the variable names. I need a,b,c in my environment.</p>