[R-sig-DB] RMySQL dbSendQuery

[Herve Pages]

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 using fhcrc.org
 Phone: (206) 667-5791
   Fax: (206) 667-1319