annovarR (version 1.0.0)

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

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

# NOT RUN {
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'))
# }