Hi,

Steven i just solved it.

the problem was with RMYSQL, not with the subset.

> dbWriteTable(..., row.names=FALSE) solved my problem...

thanks, sorry for the inconvenience.

2011/7/6 Steven Kennedy <stevenkennedy2263@gmail.com>

> What function are you using to export your data.frame to MySQL?
>
>
>
> On Wed, Jul 6, 2011 at 10:41 PM, Thiago Clark <clark.thiago@gmail.com>
> wrote:
> > Dear R-helpers,
> >
> > I have a huge dataset and I create a filter selecting only the cases I
> want
> > using:
> >>data <- subset(data, data$var=='x' | data$var=='y' | data$var=='z' | ...
> )
> >
> > The problem is, when i check my new data it doen't show a row_names
> column
> > but when the data is exported to MYSQL (using RMYSQL) it creates a column
> > row_names.
> >
> > I've already tried
> >>row.names(data)<- NULL
> > tried
> >>write.table
> > then
> >>read.table
> >
> > tried
> >>as.matrix(data)
> >
> > but the row_names column does not appear in R, but appears everytime I
> > export to MYSQL
> >
> > I've done a similar work with another dataset but the difference was that
> in
> > the filter I used
> >>data <- subset(data, substr(as.numeric(data$var),1,2==0 |
> > substr(as.numeric(data$var),1,2==1 |  ... )
> >
> > I don't know how to get rid of that column.
> >
> > thanks
> >
> >        [[alternative HTML version deleted]]
> >
> > ______________________________________________
> > R-help@r-project.org mailing list
> > https://stat.ethz.ch/mailman/listinfo/r-help
> > PLEASE do read the posting guide
> http://www.R-project.org/posting-guide.html
> > and provide commented, minimal, self-contained, reproducible code.
> >
>

	[[alternative HTML version deleted]]

