RMySQL question
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