Problem inserting data into MySQL from R

General
,
1

good afternoon and thanks for reading. I currently have to manually enter data into SQL and am trying to automate the data using a loop in R, but when entering the query and reviewing the information in MySQL, I don't see any new observations added.

Basically, that's the code to input the observations that I'm using (using other data that I'm looping out of a data frame):

library(dplyr)
library(odbc)
library(DBI)
library(RMySQL)

connection <- dbConnect(RMySQL::MySQL(),
                        dbname = "xxx",
                        host=  "xxx",
                        port = xxx,
                        user = "xxx",
                        password = "xxx")

payout_history <- paste0("INSERT INTO `payout_history` (`uuid`, `trip_id`, `delivery_order_id`, `amount`, `payout_type_id`, `payout_invoice_id`) VALUES (uuid(), '",id,"', '",order_id,"', '",amount,"', '7', '",head(payout_invoice$id,1),"');")
    
dbExecute(connection,payout_history)

The query works when I try to use it within the MySQL manager, but within the R console with the dbExecute() function it doesn't add anything, do you know if I should use any other function to be able to insert observations?

2

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.