View Single Post
Join Date: Oct 2008
Posts: 9
Reputation: bvssam is an unknown quantity at this point 
Solved Threads: 0
bvssam bvssam is offline Offline
Newbie Poster

Re: Transfer of data

 
0
  #5
Nov 21st, 2008
Hi,

Sorry For the delayed reply.

The functionality db of my appplication is around two tables
both of different structures.

Table1chedule
Table2:Out


Schedule(id,recipient,Text,TimetoSend)
Out(id,recipient,text,...........)

Ok SO the Table Schedule is populated before and when ever the "Timetosend " equals to that of system time then the selected rows whose feild value(TimeToSend)
should be copied to Table Out


I would like to know how to solve this minor task

when I googled a bit I found "mysql.event" ,Can I Use the same here.... if so please let me know how to do so.


Thanks in Advance.
Reply With Quote