dbBuildTableDefinition {RMySQL} | R Documentation |
Build the SQL CREATE TABLE definition as a string for the input data.frame
dbBuildTableDefinition(dbObj, name, obj, field.types = NULL, row.names = TRUE, ...)
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 |
The output SQL statement is a simple CREATE TABLE
with
suitable for dbGetQuery
An SQL string
See the Database Interface definition document
DBI.pdf
in the base directory of this package
or http://stat.bell-labs.com/RS-DBI.
MySQL
,
dbConnect
,
dbSendQuery
,
dbGetQuery
,
fetch
,
dbCommit
,
dbGetInfo
,
dbReadTable
.