library(DBI)
connection <- dbConnect(RMySQL::MySQL(),
dbname = "name",
host = "adress.amazonaws.com",
port = number,
user = "id",
password = "pw")
info <- dbGetQuery(connection, "SELECT column1 FROM database WHERE argument = something")
info
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter