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

In JhuangLab/annovarR: Integrated Framework to Annotate Genetic Variants

Description

Generate search index of anor 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 = 'anor')
## 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)

JhuangLab/annovarR documentation built on April 23, 2020, 10:51 p.m.