RMySQL (version 0.4-6)

methods.MySQL: Support MySQL methods

Description

MySQL support methods. For details on what it does, see the documentation of the generic function.

Usage

assignTable.MySQLConnection(con, name, value, field.types, row.names, overwrite, append, ...)

Arguments

con

an MySQL connection.

name

the name of the MySQL table to create, overwrite, or append to.

value

a data.frame to be exported to the DBMS

row.names

field name in value to be mapped to a row_names MySQL column. By default row.names(value) is added as the first column of the value data.frame, and this expanded data.frame is tra

field.types

a list with as many elements as fields in the target MySQL table. Each member of the list maps the corresponding field in value into a MySQL data type. By default, this argument is built by invoking

overwrite

logical specifying whether to overwrite an existing MySQL table or not.

append

logical specifying whether to append to an existing MySQL table or not.

...

additional arguments are silently ignored.

Details

See help(generic) for a description of the functionality that this method provides in the context of the MySQL driver.

See Also

On database managers:

dbManager MySQL load unload

On connections, SQL statements and resultSets:

dbExecStatement dbExec fetch quickSQL

On transaction management:

commit rollback

On meta-data:

describe getVersion getDatabases getTables getFields getCurrentDatabase getTableIndices getException getStatement hasCompleted getRowCount getAffectedRows getNullOk getInfo

Examples

m <- dbManager("MySQL")
con <- dbConnect(m, user="opto", pass="pure-light", dbname="opto")