Message-ID: <e65c720769e4cba81c0d32bad2defa9f@tin.it>
Date: 2005-04-02T21:10:52Z
From: Simone Gabbriellini
Subject: RMySQL question
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