Read from a MySQL/MariaDB database — tl_read

Connects to a MySQL or MariaDB database, executes a SQL query, and returns the result as a tidylearn_data object. Accepts either a connection string or individual connection parameters. Requires DBI and RMariaDB.

Usage

tl_read_mysql(
  dsn,
  query,
  dbname = NULL,
  user = NULL,
  password = NULL,
  port = 3306,
  ...
)

Arguments

dsn: A MySQL connection string (e.g., "mysql://user:pass@host:port/dbname"), or the database host if using named parameters.
query: A SQL query string.
dbname: Database name (if not in dsn).
user: Username (if not in dsn).
password: Password (if not in dsn).
port: Port number. Default is 3306.
...: Additional arguments passed to DBI::dbConnect().

Value

A tidylearn_data object containing the query results.

Examples

# \donttest{
# data <- tl_read_mysql(
#   dsn = "localhost",
#   query = "SELECT * FROM my_table",
#   dbname = "mydb",
#   user = "myuser",
#   password = "mypass"
# )
# }