mysqlBuildTableDefinition: Build the SQL CREATE TABLE definition as a string

Description Usage Arguments Value

View source: R/extension.R

Description

The output SQL statement is a simple CREATE TABLE with suitable for dbGetQuery

Usage

1
2
mysqlBuildTableDefinition(dbObj, name, obj, field.types = NULL,
  row.names = TRUE, ...)

Arguments

dbObj

any DBI object (used only to dispatch according to the engine (e.g., MySQL, Oracle, PostgreSQL, SQLite)

name

name of the new SQL table

obj

an R object coerceable to data.frame for which we want to create a table

field.types

optional named list of the types for each field in obj

row.names

logical, should row.name of value be exported as a row\_names field? Default is TRUE

...

reserved for future use

Value

An SQL string


rstats-db/rmysql documentation built on May 19, 2018, 10:21 p.m.