dbTalk Databases Forums  

Importing data into blob.....Help Me

mailing.database.myodbc mailing.database.myodbc


Discuss Importing data into blob.....Help Me in the mailing.database.myodbc forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
gbattine
 
Posts: n/a

Default 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.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.