Category "rmysql"

Insert NA values in Mysql table RMySQL

I am trying to insert a data frame row in a mysql table, but I have NA values in character and numeric columns. I'm getting this error: Error in .local(conn, st

I would like to use R Shiny to upload csv data to MySQL table and display

Apologies for the long question. I wrote the following R script to upload/append some csv files i get on a regular basis to a MySQL database. The examples files

Sending Queries to a table in RMySQL, using R variables

I am trying to write data I have created in R and stored in arrays to MySQL table. Currently this is how I am doing it, for(z in 1:60){ dbSendQuery( mydb,