Loading File Into Blob Fields To Mysql

[eskimmer 0]

Hi all!does any know how to load file into blob filed by sql script?

[iGuest 3]

Saving a resultset into file

Loading File Into Blob Fields To Mysql

 

Hi,

I am newbee to Mysql, so not much aware of the syntax.

I want to copy the resultset of a table into a file like

 

SELECT * INTO OUTFILE 'data.Txt'

FIELDS TERMINATED BY ','

FROM ...

 

But my problem is that the query will be used in a stored procedure and the filename and delimiter will be passed during runtime.

 

Please provide any solution if possible.

 

-question by Sourendra