mysql.index: Generate search index of annovarR database table in mysql

In annovarR: Integrated Framework to Annotate Genetic Variants

Description

Generate search index of annovarR database table in mysql

Usage

mysql.index(mysql.connect.params = list(host = "", dbname = "", table.name =
  "", user = "user", password = "password"), index = "", cols = c(),
  verbose = FALSE, ...)

Arguments

mysql.connect.params	Mysql parameters, [host, dbname, table.name, user, password etc.]
index	Index name in mysql
cols	Colnames needed with length to be index (e.g. c('V1(6)', 'V2'))
verbose	Ligical indicating wheather show the log message
...	Other parameters be used in dbSendQuery

Examples

test.dat <- system.file('extdata', 'demo/sqlite.dat.txt', package = 'annovarR')
## Not run: 
mysql.index(list(host = 'host', dbname = 'db', table.name = 'table', 
user = 'user', password = 'password'), index = 'index_name', cols = c('V1', 'V2'))

## End(Not run)

annovarR documentation built on Jan. 9, 2018, 5:05 p.m.