I have a database in MySQL and I'm able to send queries and get data from my database without an issue. I also know about the dbWriteTable() command but that seems to be only used if you're writing in an entirely new entry. E.g., if my table has attributes, "name" "age" and "major" then dbWriteTable() must have all three attributes.
What I want is to update major while keeping the name and age that are already in the database. Please let me know if more info is needed. I'd really like to figure out how to do this :)
Edit: RMySQL is the R package.