Displaying 1 result from an estimated 1 matches for "datafromdb".
2007 Mar 01
2
Query about data manipulation
...use some input.
I am retreiving data from a MySQL database using
RODBC.
The table has many BLOB columns and each BLOB column
has data in the format
"id1 \t id2 \t measure \n id3 \t id4 \t measure...."
(i.e. multiple rows compressed as one long string)
I am retreiving them as follows.
dataFromDB <- sqlQuery(channel, "select
uncompress(columnName) from tableName");
I am looking for ways to convert this long "string"
into a table/dataframe in R, making it easier for
further post processing etc without reading/writing it
to a file first.
Although by doing write.table...