Questions tagged [rmysql]

An R package for interfacing with MySQL and MariaDB databases.

RMySQL is an package providing an interface to and databases. RMySQL uses the interface which is also used by the packages , , , and .

Repositories

Other resources

Related tags

418 questions
0
votes
1 answer

How do I install and configure RMySQL to connect to a remote MySQL database (AWS RDS)?

The system info relevant to my problem: AWS RDS DB Instance Instance Class - db.m1.small Engine - MySQL 5.6.13 AWS EC2 Linux AMI https://aws.amazon.com/amazon-linux-ami/2014.03-release-notes/ R version 3.0.2 i686-redhat-linux-gnu (32-bit) Linux…
nhuff717
  • 369
  • 2
  • 3
  • 17
0
votes
0 answers

Extracting data from data frame in R

I am very new to R (computer programming in general) and am working on a bioinformatics project. I made a MySQL database and using RMySQL connected to that database in the MySQL server in R. From here I issued queries to select a certain field from…
0
votes
1 answer

Changing library location

So I'm relatively new to using r-studio and I'm having a problem installing RMySQL. I'm running RStudio 0.98.501 and R 3.0.2 and trying to connect R to a database. However, whenever I try to install RMySQL I get the error message "package ‘RMySQL’…
0
votes
1 answer

Create Time series with MySQL data in R Shiny

I'm trying to develop a dashboard using R Shiny which extract data from a MySQL database and represents it in graphical form. I need to create a time series using several data. But a problem occurs when the time stamp values in MySQL cannot be…
Thisara Watawana
  • 344
  • 4
  • 15
0
votes
1 answer

R join 2 data frames

Hello i would like to know how can i merge 2 data frames in R,there is a merge function ,but i would like to do this : data frame1 X Y Z 1 1 1 1 2 1 1 1 3 1 1 1 4 1 1 1 5 1 1 1 data frame 2 A B C 1 2 2 2 2 2 2 2 3 2 2…
0
votes
0 answers

MySQL Query and POSIXct in Loop

I have the following MySQL Query using RMySQL. All the Database parameters are set before and Query is working well. Is there a possibility to put it in a loop to get multiple zoo objects from more than one dpname?…
Herr Student
  • 853
  • 14
  • 26
0
votes
1 answer

Mixing single and double quotes in the R paste function?

This seems ridiculous, but I just can't get this right - any help much appreciated please! Basically: I'm using RMySQL to do some simple SQL, in order to get my head around how SQL works. I'd like to chain together a few SQL select queries, as a…
HypersonicNinja
  • 99
  • 1
  • 12
0
votes
2 answers

Connecting R-Studio with MySQL leads to errors (Windows)

I used this guide: Using MySQL in R for Windows but it didn't help. I'm already searching for hours on this problem. Since I can't figure out my problem I just can send here the log when trying to install.packages('RMySQL',type='source') > Warning…
kwoxer
  • 3,734
  • 4
  • 40
  • 70
0
votes
0 answers

R RMySQL not escaping table name, conflicts with MySQL reserved keyword

Code: dbWriteTable(con, name=symbol, value=df, row.names=FALSE, append=TRUE) Error in mysqlExecStatement(conn, statement, ...) : RS-DBI driver: (could not run statement: You have an error in your SQL syntax; check the manual that corresponds to…
ctrlbrk
  • 1,174
  • 2
  • 17
  • 27
0
votes
1 answer

SELECT statement from two dataframes using RMySQL

Consider two data frames, dataFrame1 and dataFrame2: dataFrame1 has N columns (colmn1, ..., colmnN) dataFrame2 has 3 columns (col1, col2, col3) Can I write a statement like: Select colmn1, colmn2, ..., colmnN, col1, col2 from dataFrame1,…
0
votes
0 answers

dbWriteTable from R to MySQL returns unwanted null rows

I have a data.frame (table_2) of 12531 rows and 92 cols and I would like to load it into MySQL using 'RMySQL' package, so... dbWriteTable(con,'DB.table_2',table_2,row.names=F) Checking the output in MySQL, I see that the table has 3 rows more, with…
chri
  • 1
  • 1
0
votes
0 answers

Passing arguments to queries in RMySQL

I m relatively new to R. I m using the RMySQL Library to get some data and then process it in R. My code looks something like this. arg<-commandArgs(TRUE) rs<-dbSendQuery(con, "select owner_name, domain, count(*) as freq from playlist where…
m_amber
  • 747
  • 3
  • 13
  • 23
0
votes
1 answer

Serialized object to mysql database in R

If I have serialized data like: > a <- 1:5 > a [1] 1 2 3 4 5 > b <- serialize(a,NULL) > b [1] 58 0a 00 00 00 02 00 02 0f 02 00 02 03 00 00 00 00 0d 00 00 00 05 00 00 00 01 00 00 00 02 00 00 00 03 00 00 00 04 00 00 00 05 > b[1] [1] 58 > b[8] [1]…
TheLaama
  • 307
  • 2
  • 4
  • 12
0
votes
1 answer

RStatistics: Setting date as variable in MySQL Query

Connecting to a database via RMySQL I wrote some R-scripts - to make them easier: Is it possible to set the date in MySQL Query as a variable? e.g. x<-"2012-12-01" rs <- dbGetQuery(db,"**** where date between 'x' and '2012-12-31'") Is there any…
Herr Student
  • 853
  • 14
  • 26
0
votes
1 answer

Trouble installing RMySQL on Windows 8

I followed the installation directions at R-Bloggers website. However once I do the install.packages('RMySQL',type='source'), I get the following error. It appears that there is some conflict with regards to the path (Windows likes backward slashes…
user721975
  • 1,257
  • 3
  • 13
  • 14
1 2 3
27
28