annovarR (version 1.0.0)

mysql.build: Build annovarR database in mysql

Description

Build annovarR database in mysql

Usage

mysql.build(filename = "", mysql.connect.params = list(host = "", dbname =
  "", table.name = "", user = "", password = ""), dat = data.table(),
  fread.params = list(), new.colnames = NULL, verbose = FALSE, ...)

Arguments

filename

Path of raw data, will be read by fread

mysql.connect.params

Mysql parameters, [host, dbname, table.name, user, password etc.]

dat

Object of data.table, as the input data to build database

fread.params

Other parameters be used in fread

new.colnames

New colnames of table, default is to retain the original

verbose

Ligical indicating wheather show the log message

...

Other parameters be used in dbWriteTable

Examples

# NOT RUN {
test.dat <- system.file('extdata', 'demo/sqlite.dat.txt', package = 'annovarR')
# }
# NOT RUN {
mysql.build(test.dat, list(host = 'host', dbname = 'db', 
table.name = 'table', user = 'user', password = 'password'))
# }

Run the code above in your browser using DataCamp Workspace