Re: [R] sqldf modify table

On Fri, Jul 16, 2010 at 2:46 PM, PeterTucker wrote: > > Hi - I am something of a newbie and am a little perplexed.  When (trying to) > modify a table I issue the following commands with subsequent errors > > sqldf("alter table Korea drop column code", dbname = "mydb") > error in statement: near "d

[R] sqldf modify table

Hi - I am something of a newbie and am a little perplexed. When (trying to) modify a table I issue the following commands with subsequent errors sqldf("alter table Korea drop column code", dbname = "mydb") error in statement: near "drop": syntax error or sqldf("alter table Korea rename column