Retrieve table names in a MySQL database (referenced by 'edb').

Share:

Description

Retrieve table names in a MySQL database (referenced by 'edb').

Usage

1
2
## S3 method for class 'RODBC_MySQL'
edbNames(edb, onlyNames = TRUE, ...)

Arguments

edb

An object of class 'edb', such as returned by edb.

onlyNames

Single logical. If TRUE only returns the table names (vector),

and if FALSE returns a detailed table as in

sqlTables.

...

Additional parameters to be passed to dbListTables.

Value

The function returns the list of tables found in the database.

Author(s)

Julien MOEYS <Julien.Moeys@mark.slu.se>

See Also

edb, edbRead.RODBC_MySQL,

edbWrite.RODBC_MySQL,

edbColnames.RODBC_MySQL.

Examples

  1
  2
  3
  4
  5
  6
  7
  8
  9
 10
 11
 12
 13
 14
 15
 16
 17
 18
 19
 20
 21
 22
 23
 24
 25
 26
 27
 28
 29
 30
 31
 32
 33
 34
 35
 36
 37
 38
 39
 40
 41
 42
 43
 44
 45
 46
 47
 48
 49
 50
 51
 52
 53
 54
 55
 56
 57
 58
 59
 60
 61
 62
 63
 64
 65
 66
 67
 68
 69
 70
 71
 72
 73
 74
 75
 76
 77
 78
 79
 80
 81
 82
 83
 84
 85
 86
 87
 88
 89
 90
 91
 92
 93
 94
 95
 96
 97
 98
 99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
library( "easyrodbcmysql" ) 











testMySQL <- FALSE # Set to TRUE to run some tests


                   # after modifying the edb() part below 


                   # with your own database setting











### Windows only:


if( (Sys.info()[[ "sysname" ]] == "Windows") & testMySQL ){ 


    


    ### Describe the database (NB: this is not a connection)


    myDb <- edb( 


        dbType       = "RODBC_MySQL", 


        dbSourceName = "nameOfODBCSource", # or any name you like


        dbName       = "nameOfDatabase", 


        dbLogin      = "yourUserName", 


        dbPwd        = "yourPassword", 


        dbHost       = "127.0.0.1", 


        dbPort       = 3306 


    )   #    


    


    


    


    ### Register the data source in ODBC 


    edbDataSource( myDb, verbose = TRUE ) 


    


    


    


    ### Use the database:


    


    # List the table names in the database:


    edbNames( edb = myDb ) 


    


    # with more details


    edbNames( edb = myDb, onlyNames = FALSE ) 


    


    


    


    ### Un-register the data source in ODBC (windows only)


    edbDataSource( myDb, trash = TRUE ) 


}   #