CODEWITHSUNDEEP
r
user4865980
user4865980

Reputation:

Refer database tables in R

I have a database name Team which has 40 tables . How can I connect to that database and refer to particular table without using sqlquerry. By the use of R data Structures.

Upvotes: 0

Views: 87

Answers (1)

p.marino
p.marino

Reputation: 6252

I am not sure what do you mean with "How can I connect to that database and refer to particular table without using sqlquerry".

I am not aware of a way to "see" DB tables as R dataframes or arrays or whatever without importing the tuples first through some sort of query (in SQL) - this seems to be the most practical way to use R with DB data (without going to the hassle of exporting these as .csv files first, and re-read them in R).

There are a couple ways to import data from a DB to R, so that the result of a query becomes a R data structure (including proper type conversion, ideally).

Upvotes: 1

Related Questions