RMySQL (version 0.10.25)

mysqlBuildTableDefinition: Build the SQL CREATE TABLE definition as a string

Description

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

Usage

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

Value

An SQL string

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