mysql_query: Wrapper for querying the R&D MySQL instances
In wikimedia-research/WMUtils: Utilities for Wikimedia staffers
Description
Usage
Arguments
Value
Author(s)
See Also
Description
mysql_query is a simple wrapper around RMySQL that allows a useR to query the dbs on
analytics-store.eqiad.wmnet.
Usage
1
mysql_query(query, db, dt = TRUE)
Arguments
query
the SQL query you want to run.
db
the name of the database you want to run the query against.
dt
whether to return the results as a data.table. TRUE by default.
Value
A data.frame or data.table containing the results of the query.
Author(s)
Oliver Keyes <okeyes@wikimedia.org>
See Also
global_query for querying multiple "production" databases in
analytics-store.eqiad.wmnet with a common query, mw_strptime for converting
MediaWiki timestamps into POSIXlt timestamps, mysql_delete for removing rows
from a table that match a set of conditions, mysql_exists for checking the existence
of a table, or mysql_write for writing to a table.
wikimedia-research/WMUtils documentation built on May 4, 2019, 5:23 a.m.
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Description Usage Arguments Value Author(s) See Also
Description
mysql_query is a simple wrapper around RMySQL that allows a useR to query the dbs on
analytics-store.eqiad.wmnet.
Usage
1 | mysql_query(query, db, dt = TRUE)
|
Arguments
query |
the SQL query you want to run. |
db |
the name of the database you want to run the query against. |
dt |
whether to return the results as a data.table. TRUE by default. |
Value
A data.frame or data.table containing the results of the query.
Author(s)
Oliver Keyes <okeyes@wikimedia.org>
See Also
global_query for querying multiple "production" databases in
analytics-store.eqiad.wmnet with a common query, mw_strptime for converting
MediaWiki timestamps into POSIXlt timestamps, mysql_delete for removing rows
from a table that match a set of conditions, mysql_exists for checking the existence
of a table, or mysql_write for writing to a table.
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Embedding an R snippet on your website
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.