[R] RMySQL question

[David James]

simone gabbriellini wrote:
> Dear List,
> I have this little problem:
> 
> I work with adiacency matrix like:
> 
> data	me you
> me 	0	1
> you	1	0
> 
> I store those matrix in a mysql database
> 
> actually I use RMySQL with:
> 
> res<-dbSendQuery(connection, "SELECT * FROM table")
> myDataFrame<-fetch(res)
> 
> to retrive the table, and I have
> 
>     data me  you
> 1  io     0     1
> 2  tu     1     0
> 
> I would like the first column to be seen not as data, but as label, 
> like:
> 
> data me  you
> io      0     1
> tu      1     0
> 
> should I change something in the table structure in mysql, or should I 
> tell R something particular like "the first column is not data"? If so, 
> how?
> 
> hope I have expressed well my intent
> thanx in advance
> 
> simone
> 

Hi,

In this case, since you are extracting all the rows you could simply try

  > dbReadTable(connection, "table", row.names = 1)

See help(dbReadTable) for more details.

Hope this helps,

--
David