mysqlBuildTableDefinition: Build the SQL CREATE TABLE definition as a string

In RMySQL: Database Interface and 'MySQL' Driver for R

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,
  ...
)

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

RMySQL documentation built on Sept. 11, 2024, 6:11 p.m.