[R-sig-DB] RMySQL dbSendQuery

Herve Pages hpages at fhcrc.org
Fri Oct 14 22:21:47 CEST 2005


Parlamis Franklin wrote:

>When the following statement:
>
>     dbSendQuery(MySQL.Connection, "source ~/MySQLFiles/DateTable.sql")
>
>  
>
As Douglas said, "source" is not an SQL statement.

Remember, MySQL is a client/server RDBMS. The client (your R program)
and the server can be on different machines. So when the server receives
the following statement "source ~/MySQLFiles/DateTable.sql", how could it
find the file "~/MySQLFiles/DateTable.sql"?

-- 
------------------------
Hervé Pagès
E-mail: hpages at fhcrc.org
 Phone: (206) 667-5791
   Fax: (206) 667-1319




More information about the R-sig-DB mailing list