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

Link to MySQL database and extract column names of table in database.

1
2
3

list_VN_mysql(database, table_name, username, password)

list_VN_flat(wkdir, database, table_name)

`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.
`wkdir`	The path to working directory. See `initWkdir` for details on a working directory.