Question

How to create a new table in database from R?

Answer 1

Use dbGetQuery to create a table by writing create a statement as below.

Ex:

> db = dbConnect(odbc(),
               Driver = "MySQL ODBC 5.3 ANSI Driver",
               Server = "127.0.0.1",
               database = "wrgwrgrge",
               uid = "fawgawrgwrg",
               pwd = "sdawf")

> dbGetQuery(db,"create table dummy ( Id INT PRIMARY KEY,Name VARCHAR(5))")

data frame with 0 columns and 0 rows