Read from database and store in R as dataframe

Question

Hi, im new to R and want to connect to database, but cant read the table. How to read from database and store in R as dataframe? 

If i use below command to store directly from database to R, it return ssomeother datatype of variable.

Answer 1

Your code would fetch you a MySQL object, so use dbReadTable() function 

Use code like below - 

> table_name <- dbReadTable(mydb,"new_table_name")