mysqlBuildTableDefinition

The output SQL statement is a simple <code>CREATE TABLE</code> with suitable for
<code>dbGetQuery</code>

internal

Legacy 'DBI' interface to 'MySQL' / 'MariaDB' based on old code
ported from S-PLUS. A modern 'MySQL' client written in 'C++' is available
from the 'RMariaDB' package.

Jeroen Ooms

RMySQL

Database Interface and 'MySQL' Driver for R

David James

Saikat DebRoy

Hadley Wickham

Jeffrey Horner

RStudio 

mysqlBuildTableDefinition function

<dl><dt>dbObj</dt>
<dd>any DBI object (used only to dispatch according to the engine
(e.g., MySQL, Oracle, PostgreSQL, SQLite)</dd>
<dt>name</dt>
<dd>name of the new SQL table</dd>
<dt>obj</dt>
<dd>an R object coerceable to data.frame for which we want to create
a table</dd>
<dt>field.types</dt>
<dd>optional named list of the types for each field in
<code>obj</code></dd>
<dt>row.names</dt>
<dd>logical, should row.name of <code>value</code> be exported as a
<code>row\_names</code> field? Default is TRUE</dd>
<dt>...</dt>
<dd>reserved for future use</dd></dl>

Arguments

Build the SQL CREATE TABLE definition as a string — mysqlBuildTableDefinition

<dl>

<dt>dbObj</dt>
<dd>any DBI object (used only to dispatch according to the engine
(e.g., MySQL, Oracle, PostgreSQL, SQLite)</dd>


<dt>name</dt>
<dd>name of the new SQL table</dd>


<dt>obj</dt>
<dd>an R object coerceable to data.frame for which we want to create
a table</dd>


<dt>field.types</dt>
<dd>optional named list of the types for each field in
<code>obj</code></dd>


<dt>row.names</dt>
<dd>logical, should row.name of <code>value</code> be exported as a
<code>row\_names</code> field? Default is TRUE</dd>


<dt>...</dt>
<dd>reserved for future use</dd>

</dl>

mysqlBuildTableDefinition: Build the SQL CREATE TABLE definition as a string

Description

Usage

Value

Arguments