How to insert Data into the MySQL Tables using R

Question

Hi Team,

I am able to connect to the MySQL server from RStudio. Now I want to insert data into a MySQL table using R. How can I do that?

Answer 1

Hi@akhtar,

Before you try to insert the data into the MySQL table, make sure you have configured your R to connect with MySQL. After that, you can use the below command.

dbSendQuery(mysqlconnection,
   "insert into mtcars(row_names, mpg, cyl, disp, hp, drat, wt, qsec, vs, am, gear, carb) values('New Mazda RX4 Wag', 21, 6, 168.5, 110, 3.9, 2.875, 17.02, 0, 1, 4, 4)"
)