Library for execution of any SQL command. Available on CRAN.

  1. Installation:
    > install.packages("sqldf")
    also installing the dependencies ‘gsubfn’, ‘proto’, ‘RSQLite’, ‘chron’
    
    trying URL 'https://cran.rstudio.com/bin/windows/contrib/3.2/gsubfn_0.6-6.zip'
    Content type 'application/zip' length 348602 bytes (340 KB)
    downloaded 340 KB
    
    trying URL 'https://cran.rstudio.com/bin/windows/contrib/3.2/proto_0.3-10.zip'
    Content type 'application/zip' length 458603 bytes (447 KB)
    downloaded 447 KB
    
    trying URL 'https://cran.rstudio.com/bin/windows/contrib/3.2/RSQLite_1.0.0.zip'
    Content type 'application/zip' length 1217841 bytes (1.2 MB)
    downloaded 1.2 MB
    
    trying URL 'https://cran.rstudio.com/bin/windows/contrib/3.2/chron_2.3-47.zip'
    Content type 'application/zip' length 109179 bytes (106 KB)
    downloaded 106 KB
    
    trying URL 'https://cran.rstudio.com/bin/windows/contrib/3.2/sqldf_0.4-10.zip'
    Content type 'application/zip' length 71807 bytes (70 KB)
    downloaded 70 KB
    
    package ‘gsubfn’ successfully unpacked and MD5 sums checked
    package ‘proto’ successfully unpacked and MD5 sums checked
    package ‘RSQLite’ successfully unpacked and MD5 sums checked
    package ‘chron’ successfully unpacked and MD5 sums checked
    package ‘sqldf’ successfully unpacked and MD5 sums checked
    
    The downloaded binary packages are in
    	C:\Users\TestUser\AppData\Local\Temp\Rtmp0ESDDq\downloaded_packages
    
  2. Loading:
    > library(sqldf)
    Loading required package: gsubfn
    Loading required package: proto
    Loading required package: RSQLite
    sqldf will default to using PostgreSQL
    
  3. Usage: