如何在mysql中创建事件或作业以合并文件中的内容 [英] How to create an event or job in mysql to merge the content in the files
问题描述
大家好,我的要求不高,所以我想知道为此创建一个活动或工作是一件好事.假设一天结束时我的表中有3个文件,则我必须将所有3个文件合并到一个文件中,以便将这3个文件中显示的内容合并到一起,并应显示在文件中并具有将以一些文件名保存在表中,并且还将保存内容,我将在我的表中将其声明为blob以保存内容
如果可能的话,任何人都可以给我一个实现此目标的想法.
包含文件的初始表如下
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
FileName Content<br />
Xyz.txt Blob<br />
ABC.txt Blob<br />
NOP.txt Blob
我必须从表中读取每个文件名和内容,并且必须将它们全部合并在一起.
I have to read each and every file name and content from the table and has to merge them all together
推荐答案
请阅读此内容.
http://dev.mysql.com/tech-resources/articles/breadboardbi_data_warehouse.html [ ^ ]
Please read this.
http://dev.mysql.com/tech-resources/articles/breadboardbi_data_warehouse.html[^]
这篇关于如何在mysql中创建事件或作业以合并文件中的内容的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!