make.db.names-methods {RMySQL} | R Documentation |
These methods are straight-forward implementations of the corresponding generic functions.
MySQLDriver
).
TRUE
. Following the SQL 92
standard, uniqueness of SQL identifiers is determined regardless
of whether letters are upper or lower case.
TRUE
.MySQLKeywords
define in RMySQL
. This may
be overriden by users.
any
.
The set of SQL keywords is stored in the character vector
.SQL92Keywords
and reflects the SQL ANSI/ISO standard as
documented in "X/Open SQL and RDA", 1994, ISBN 1-872630-68-8.
Users can easily override or update this vector.
MySQL does add some keywords to the SQL 92 standard, they are
listed in the .MySQLKeywords
object.
See the Database Interface definition document
DBI.pdf
in the base directory of this package
or http://stat.bell-labs.com/RS-DBI.
MySQL
,
dbReadTable
,
dbWriteTable
,
dbExistsTable
,
dbRemoveTable
,
dbListTables
.
## Not run: # This example shows how we could export a bunch of data.frames # into tables on a remote database. con <- dbConnect("MySQL", "user", "password") export <- c("trantime.email", "trantime.print", "round.trip.time.email") tabs <- make.db.names(export, unique = T, allow.keywords = T) for(i in seq(along = export) ) dbWriteTable(con, name = tabs[i], get(export[i])) ## End(Not run)