dbExecStatement {RMySQL}R Documentation

Execute an SQL statement on a given database connection

Description

Submits and executes an arbitrary SQL statement on a specific connection.

Usage

dbExecStatement(con, statement, ...)

Arguments

con a connection object (i.e., an object that extends dbConnection).
statement a character vector of length 1 with the SQL statement.
... database-specific parameters may be specified.

Details

This function only submits and executes the SQL statement to the database engine. It does not extracts any records: for that you need to use the function fetch.

Value

an object that extends dbResult, in the case of an SQL statement that produces no output (e.g., INSERT), or dbResultSet in the case of a SELECT-like statement.

Side Effects

The statement is submitted to the server connected through the connection con.

References

See the Omega Project for Statistical Computing at http://www.omegahat.org for more details on the R/S database interface.

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

mgr <- dbManger("MySQL")
con <- dbConnect(mgr)
rs <- dbExecStatement(con, "SELECT * from liv25")
data <- fetch(rs, n = -1)
[Package Contents]