edbNames.RODBC_MySQL: Retrieve table names in a MySQL database (referenced by...

In easyrodbcmysql: Simple Database Interface for MySQL

Description

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

Usage

## 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 <[email protected]>

See Also

edb, edbRead.RODBC_MySQL,

edbWrite.RODBC_MySQL,

edbColnames.RODBC_MySQL.

Examples

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 ) 


}   #

easyrodbcmysql documentation built on May 31, 2017, 4:09 a.m.