Will creating reports on R using MySQL Database update my database on MySQL?
0
votes
1
answer
95
views
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
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", password="", dbname ="")
Table1 <- fetch(dbSendQuery(Data, "select * from Table"),-1)
Using the
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?
Asked by mkobayashi
(3 rep)
Oct 11, 2019, 04:24 AM
Last activity: Oct 11, 2019, 06:04 AM
Last activity: Oct 11, 2019, 06:04 AM