RMySQL (version 0.4-6)

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

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.

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.

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)