Will creating reports on R using MySQL Database update my database on MySQL? I use MySQL to store my data. To analyze the data I want to be able to generate monthly reports on R. So far I was able to connect to MySQL using dbConnect but I want to make sure that none of the tweaking I do affects the database I have in MySQL. Below is the code I used to import the database/table to R. 

install.packages("RODBC")
library(RODBC)
Data&lt;-dbConnect(drv, username="&lt;insert username here&gt;", password="&lt;insert password here&gt;", dbname ="&lt;insert database name here&gt;")
Table1 &lt;- fetch(dbSendQuery(Data, "select * from Table"),-1)


Using the fetch function I am able to load the table into R but I want to make sure that I am not changing it on MySQL at the same time. Would applying any operations, adding columns etc affect the original database in MySQL?
When you copy data from MySQL into rstudio (or your UI of choice), r pulls the data into memory. 

When you then manipulate the data (by adding extra columns, for example), this happens entirely in memory &amp; the source data (in your case a MySQL query, but it could just as easily have been from a csv file etc) is not modified in any way.

r is wonderful, but requires a slightly different way of thinking than SQL - hope you’re enjoying it.