Hi, having trouble creating queries for data from the MariaDB. I need to select the weight and length for all frogs from 4 sources (CLEMSSC, MANHAKS, OKEECFL, and ROLLAMO). I must have 4 separate queries to produce 4 dataframes. Any help would be great!
This is what I have so far:
db <- dbConnect(
data <- dbGetQuery(db, "select * from frogs limit 3")
NEWdata <- dbGetQuery(db, "select weight, length from newfrogs limit 4")