Importing data into blob.....Help Me -
05-10-2006
, 06:15 AM
Hallo, i'm a new user of myslq and i have a problem, please help me.
I have my data table in which i have the first column that represents
an id and the other columns that represents data(numeric).
In my application each experiment has a random number of columns, the
first(the id) is fixed, the other change.
I have to store this data and later i have to represent it,without
manipulation;
I have created this script:
script.sql
create database example;
use example;
create table AFF(
ident varchar(10) primary key,
raw blob
);
LOAD DATA LOCAL INFILE 'AFFY.txt' INTO TABLE AFF
FIELDS TERMINATED BY ' '
;
AFFY.txt is the data file with
Id data1 data2 data3....that are the columns(separated by a space).
It's a right script?
How can i now reformat data and see it in original version?
Can you help me with the query?
Thanks very much. |