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