How to insert Data into the MySQL Tables using R

0 votes

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?

Oct 29, 2020 in Data Analytics by akhtar
• 38,130 points
28 views

1 answer to this question.

0 votes

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)"
)
answered Oct 29, 2020 by MD
• 94,990 points

Related Questions In Data Analytics

+1 vote
3 answers

How to change the value of a variable using R programming in a data frame?

Try this: df$symbol <- as.character(df$symbol) df$symbol[df$sym ...READ MORE

answered Jan 11, 2019 in Data Analytics by Tyrion anex
• 8,640 points
19,770 views
0 votes
1 answer
0 votes
1 answer

How to convert tables to a data frame in R ?

> trial.table.df <- as.data.frame(trial.table) //assuming that trial.table ...READ MORE

answered Apr 20, 2018 in Data Analytics by zombie
• 3,790 points
2,682 views
0 votes
1 answer

How to import data from a Json file into R?

Easy and simple: library("rjson") json_file <- "file_name" json_data <- fromJSON(file=json_file)) or ...READ MORE

answered Apr 26, 2018 in Data Analytics by DeepCoder786
• 1,720 points
1,220 views
+10 votes
3 answers

Which is a better initiative to learn data science: Python or R?

Well it truly depends on your requirement, If ...READ MORE

answered Aug 8, 2018 in Data Analytics by Abhi
• 3,720 points
245 views
+1 vote
1 answer

Error saying "vector size cannot be NA" when using R with data mining

You can use the removesparseterm function.  Removes sparse ...READ MORE

answered Nov 15, 2018 in Data Analytics by Maverick
• 10,840 points
1,733 views
+1 vote
2 answers
0 votes
1 answer

Trying to find frequent itemsets of a data set using arules package

Try replacing ID <- c("A123","A123","A123","A123","B456","B456","B456") item <- c("bread", "butter", "milk", ...READ MORE

answered Nov 15, 2018 in Data Analytics by Maverick
• 10,840 points
133 views
0 votes
1 answer
0 votes
1 answer

How to Identify comman pattern of the Products that sells more from a sales data base.

Hi, If you share a real database, then ...READ MORE

answered Sep 7, 2020 in Data Analytics by MD
• 94,990 points
83 views