access_ore_col: Functions to link to MySQL database and extract column name
In biostatUniBS/RDataXMan: Data Extraction Management

Functions to link to MySQL database and extract column name

Functions to link to flat database and extract column name

1
2
3

access_mysql_col(database, table_name, username, password)

access_flat_col(database, table_name, data.type)

`database`	Name of database. Should be either `private` or `public` for flat tables, indicating whether data is stored in `public_data` or `research/[research folder]/private_data`, or the actual name of database if extracting data from a database.
`table_name`	The name of dataset. File extension must be included if the data is saved as a flat file instead of in a database, e.g. 'data.csv' should be given instead of simply 'data'.
`username`	User name for accessing database if `data.type` is not `flat`. Default is `NA` for flat tables.
`password`	Password for accessing database if `data.type` is not `flat`. Default is `NA` for flat tables.
`data.type`	`flat` for flat tables and `sql` fo MySQL database.

access_mysql_col: Link to MySQL database and extract column names of table in database.
access_flat_col: Load column names of table (character string).