Edit an SQL table with R

Hello everyone,

I need to edit a SQL table directly from R:
I should enter in the server with DbConnect () function, edit the table, and disconnect from the connection.
i just don't know how to fix it. I don't know the function of the DBI package to modify SQL table
kind regards,

to learn the use of DBI you can read the vignettes.
e.g. Advanced DBI Usage (r-project.org)

okay, thank you very much.
But i don't find the DBI function to edit SQL table.

look for the subtitle

SQL data manipulation - UPDATE, DELETE and friends

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.