Re: [R] User R to create MySQL database and table

2010-05-22 Thread Prof Brian Ripley
On Sat, 22 May 2010, Waverley @ Palo Alto wrote: Hi, I am thinking about using R to create a database, then create table in MySQL server. Can I do that using RMySQL package? Maybe: it is done by SQL commands which you can use *if* you have the correct privileges. However, this is R-help,

[R] User R to create MySQL database and table

2010-05-22 Thread Waverley @ Palo Alto
Hi, I am thinking about using R to create a database, then create table in MySQL server. Can I do that using RMySQL package? I am familiar with RMySQL, and in the online help most of the sample code assumes the database exists and transact with the table inside the database. Can someone provide