demo/isql.r

require(sqlutils)
require(RSQLite)

sqlfile <- paste(system.file(package='sqlutils'), '/db/students.db', sep='')
m <- dbDriver("SQLite")
conn <- dbConnect(m, dbname=sqlfile)

hist <- isql(conn=conn, sql=getSQL('StudentSummary'))
names(hist)
hist[['commands']]
hist[['sql']]

Try the sqlutils package in your browser

Any scripts or data that you put into this service are public.

sqlutils documentation built on May 29, 2017, 10:42 a.m.