Execute INSERT query — insert • dabr

Execute INSERT query

insert(conn, ...)

# S3 method for MariaDBConnection
insert(conn, ..., quiet = FALSE)

Arguments

conn: DB connection object.
...: INSERT query and optional parameters.
quiet: Boolean flag to hide status messages.

See also

Other DB functions: close_conn(), delete(), list_tables(), open_conn_mysql(), select_all(), select(), update()

Examples

if (FALSE) {
conn <- open_conn_mysql("sys", "root")
query <- paste0(
  "INSERT INTO sys_config (variable, value, set_time, set_by) VALUES ",
  "('test_var', 999, '", Sys.time(), "', NULL)"
)
out <- insert(conn, query)
close_conn(conn)
}