rmysql Questions
7
Solved
(By object-relational mapping, I mean what is described here: Wikipedia: Object-relational mapping.)
Here is how I could imagine this work in R : a kind of "virtual data frame" is linked to a data...
5
It took a good amount of time to install RMySQL on my Linux machine but I was able to install it after changing environment variables and copy and paste lib.dll file.
However, I'm now trying to in...
3
Solved
When loading data from a MySQL table there are often warnings such as :
unrecognized MySQL field type 7 in column 26 imported as character
Unsigned INTEGER in col 3 imported as numeric
How can ...
1
(Sorry if this is very basic, I'm just not able to figure out)
I have a table t sitting in a mysql db, which looks like this: (Name is the primary key)
Current Table in DB
Name Balance
Bob 100
...
2
Solved
I'm trying to connect to remote publicly-accessible MySQL server EnsEMBL public server using RMySQL, but when I try to list the tables, an error occurs:
library(RMySQL)
mydb = dbConnect(MySQL(), ...
5
Solved
Every time I try installing RMySQL I get the following error:
Installing package into ‘/home/ehsan/R/x86_64-pc-linux-gnu-library/3.0’
(as ‘lib’ is unspecified)
* installing *source* package ‘RMySQ...
2
Solved
2
Solved
I recently installed MySQL on my computer and am trying to connect RStudio to MySQL. I followed instructions in a book as well as instructions here. However, whenever I use dbConnect() or src_mysql...
4
Solved
I have below mentioned dataframe in R.
ID Amount Date
IK-1 100 2020-01-01
IK-2 110 2020-01-02
IK-3 120 2020-01-03
IK-4 109 2020-01-03
IK-5 104 2020-01-03
I'm using ID to fetch some details from ...
5
I updated MySQL to latest version 8.0.11 yesterday and tried to use RMySQL to connect to MySQL, but it was not working and I could not find any solution.
My code:
library(RMySQL)
con <- dbCon...
3
Solved
I'm trying to run a simple query that works with MySQL or other MySQL connector API's,
SELECT * FROM `table` WHERE type = 'farmer'
I've tried various methods using the RMySQL package and they al...
2
Solved
Im trying to add data to MySQL table by using RMySQL. I only need to add one row at a time and it's not working. What I'm trying to do is this.
dbGetQuery(con,"INSERT INTO names VALUES(data[1,1], ...
Arbutus asked 25/2, 2013 at 18:34
3
In R, I have a vector, "myVector", of strings which I want to insert into a column, "myColumn", of a mysql table, "myTable". I understand I can write the sql query and run it in R using dbSendQuery...
3
Solved
I am very new to shiny and R but using shiny I am trying to connect to a database fetch the data from there. When I try to access my RShiny work on browser continuously I got an error like Cannot a...
3
I have a project with a connection that was working properly on the same device. I suddenly got the error below. And I could connect from the same device through MySQL workbench.
What could be the...
1
I am experimenting with RMySQL, and have accidentally created a connection without a handle.
dbConnect(MySQL(), user = "foo", password = "bar")
connLocalDB = dbConnect(MySQL(), user = "foo", passw...
3
Solved
I am using RMySQL to fetch some rows from a data table (the table is large so I cannot post it here but basically contains a bunch of numbers.. a total of 10 columns and about 12,000 rows). I get t...
7
Solved
I am new in R and i am trying to connect R with MySQL. I have installed mysql-5.5.22-winx64 and R-2.12.0 for 64 bit. I have already set MYSQL_HOME environment path(C:\Program Files\MySQL\MySQL Serv...
North asked 24/4, 2012 at 5:42
1
Solved
2
Solved
I am using RMySQL to query a database.
I used
df <- fetch(dbSendQuery(con, "SELECT some_col from some_table"))
and got back this message:
Error in fetch(dbSendQuery(con, "SELECT some_col f...
2
In a MySQL database, a table is encoded in utf8, but for some reason the connection is in latin1.
res <- RMySQL::dbSendQuery(con,"show variables like 'character_set_%'")
dbFetch(res)
Variable_...
3
Solved
there is the package: RMySQL
How can I bulk upload lots of data to mysql from R? I have a csv with around 1 million lines and 80 columns.
Would something like this work?
dbWriteTable(con, "test2...
Graniela asked 15/7, 2013 at 2:41
2
Solved
I created an online experiment with the shiny package for R. Let's say I have 3 reactive values called "toss", "decision" and "rating".
Additionally, I launched a MySQL database on Amazon web servi...
2
Solved
Im creating a shiny app that queries an SQL database. I want to warn the user if the queried data has entries on two dates. Moreover, I want the user to be able to select which set of data to query...
1
Solved
I am trying to use dplyr to connect to a remote database, that I usually query through a ssh tunnel.
I first set up a ssh tunnel like the following:
alias tunnel_ncg='ssh -fNg -L 3307:127.0.0.1:3...
Eldon asked 30/6, 2015 at 11:12
1 Next >
© 2022 - 2024 — McMap. All rights reserved.