[R-sig-DB] RMySQL dbSendQuery
Herve Pages
hp@ge@ @end|ng |rom |hcrc@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 using fhcrc.org
Phone: (206) 667-5791
Fax: (206) 667-1319
More information about the R-sig-DB
mailing list