how cani create an event or job in mysql to merge the content in the files

Dorababu Meka

Hi all, I am having a small requirement so i would like to know is it good create an event or job for that. Assume that i have some 3 files in my table on the end of day i have to merge all those in to a single file so that what ever content that is presented in that 3 are to be merged together and should displayed in a file and has to be saved in the table with some file name and the content also to be saved i will declare this as blob in my table to save the content

If it is possible means can any one give me an idea to achieve this.

The initial table which holds the files is as follows

File Name Content
Xyz.txt Blob
ABC.txt Blob
NOP.txt Blob

I have to read each and every file name and content from the table and has to merge them all together

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Dorababu Meka15y ago
Sutish Actually i would like to know how can i read or convert blob data to some other type and can read the content if i succeeded with that means remaining all i can
0
Suthish Nair15y ago
Dorababu, you want to do this activity on db server itself?
0
Suthish Nair15y ago
ha ha ha.. come on Crish, why are you doing this. I think, your login needs to be alerted to Admins again. Your login id already got blocked once.
0
Dorababu Meka15y ago
I only posted that crish
0
Crish15y ago
This is good question for us,

Help full link

http://stackoverflow.com/questions/5727518/is-is-good-to-create-an-event-or-job-in-mysql-to-merge-the-content-in-the-files
0