Message-ID: <20050404110501.A21542@jessie.research.bell-labs.com>
Date: 2005-04-04T15:05:01Z
From: David James
Subject: RMySQL question
In-Reply-To: <e65c720769e4cba81c0d32bad2defa9f@tin.it>; from ogabbrie@tin.it on Sat, Apr 02, 2005 at 11:10:52PM +0200
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