Bleu.
Re: Accessing MySQL Database in R
Jan 18, 2011; 12:10am — by djmuseR [User is online] djmuseR
Hi:
Because R does not have a direct interface to MySQL?
You need to load a communication package - the two most common ones are
RODBC and RMySQL. The former requires that you register your
for you.
Good luck,
Ptit Bleu.
Re: Accessing MySQL Database in R
Jan 18, 2011; 12:10am — by djmuseR [User is online] djmuseR
Hi:
Because R does not have a direct interface to MySQL?
You need to load a communication package - the two most common ones are
RODBC and RMySQL. The former requires
(connection=SERVER=localhost;DRIVER=MySQL ODBC 5.1
Driver;DATABASE=my_database;UID=root;PWD=my_password;case=tolower)
resultdb-sqlQuery(ch,SELECT * from my_table)
odbcClose(ch)
Try to modify them for your case.
I hope it will work for you.
Good luck,
Ptit Bleu.
Re: Accessing MySQL Database in R
Folks,
1. can you pelase cite the messages you are repsonding to?
2. Can you please include the original poster of the question who is not
necessarily subscribed to the list?
Thanks,
Uwe Ligges
On 18.01.2011 09:52, Joel wrote:
You could try useing '127.0.0.1' instead of 'localhost' and
You could try useing '127.0.0.1' instead of 'localhost' and see if that
works.
--
View this message in context:
http://r.789695.n4.nabble.com/Accessing-MySQL-Database-in-R-tp3221264p3221291.html
Sent from the R help mailing list archive at Nabble.com
'@'localhost' (using password: YES)
Does anyone know why these aren't equivalent?
--
View this message in context:
http://r.789695.n4.nabble.com/Accessing-MySQL-Database-in-R-tp3221264p3221264.html
Sent from the R help mailing list archive at Nabble.com
' (using password: YES)
Does anyone know why these aren't equivalent?
--
View this message in context:
http://r.789695.n4.nabble.com/Accessing-MySQL-Database-in-R-tp3221264p3221264.html
Sent from the R help mailing list archive at Nabble.com.
__
R-help
7 matches
Mail list logo