Description Usage Arguments Details Value Examples
readdbtbl
is deprecated, use dplyr::tbl
instead.
See example below.
1 | readdbtbl(tableread)
|
tableread |
name of the database table to read |
[Deprecated] Old description
Return a dplyr tbl object for the given MySQL database table tbl objects allow lazy operations. See src_mysql. The issue is that 2 table objects created with this function will not share the same source. Therefore they will not be available for a merge within the database.
a dplyr tbl object
1 2 3 4 5 6 7 8 9 10 11 12 13 | ## Not run:
# From 2017 onwards, use
con <- RMariaDB::dbConnect(RMariaDB::MariaDB(), dbname = "tradeflows")
prod <- tbl(con, "raw_comext_product")
RMariaDB::dbDisconnect(con)
# Deprecated, before 2017
readdbtbl("raw_flow_yearly") %>%
group_by(productcode) %>%
summarise(nrow = n()) %>%
arrange(nrow) %>%
kable
## End(Not run)
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.