← Back to branch summary

~ubuntu-branches/debian/squeeze/rmysql/squeeze

« back to all changes in this revision

Viewing changes to man/RMySQL-package.Rd

  • Committer: Bazaar Package Importer
  • Author(s): Dirk Eddelbuettel
  • Date: 2007-08-22 06:07:51 UTC
  • mfrom: (2.1.6 gutsy)
  • Revision ID: james.westby@ubuntu.com-20070822060751-p40asvlcowm7u7au
Tags: 0.6.0-2
http://bugs.debian.org/439093
* debian/control: Updated (Build-)Depends: on r-cran-dbi (Closes: #439093)
* debian/control: Upgraded (Build-)Depends: to r-base-core (>= 2.5.1)

Show diffs side-by-side

added added

removed removed

Lines of Context:
man/RMySQL-package.Rd
43
43
   d1 <- fetch(rs, n = 10000)
44
44
   d2 <- fetch(rs, n = -1
45
45
   }
 
46
\item Run multiple SQL statements and process the various result sets 
 
47
   (note the \code{client.flag} value in the \code{dbConnect} call):
 
48
   \preformatted{
 
49
   con <- dbConnection(MySQL(), dbname = "rs-dbi", 
 
50
             client.flag = CLIENT\_MULTI\_STATEMENTS)
 
51
   script  <- paste("select * from WL where width\_nm between 0.5 and 1"
 
52
                    "select * from lasers\_id  where id LIKE 'AL100%'
 
53
                    sep = ";")
 
54
   rs1 <- dbSendQuery(con, script)
 
55
   d1 <- fetch(rs1, n = -1)
 
56
   if(dbMoreResults(con)){
 
57
      rs2 <- dbNextResult(con)
 
58
      d2 <- fetch(rs2, n=-1)
 
59
   }
 
60
   }
46
61
\item Get meta-information on a connection (thread-id, etc.):
47
62
   \preformatted{
48
63
   summary(MySQL(), verbose = TRUE)