Transfer of data
 

Hii Group,

This is samuel Like to hav a small suggestion from you hope u ppl do.
"I would like to copy dat from one table to another of the same database in a give
timestamp,I mean when system time equals to the feild time then the entire data should
be transfered Will it be possible in MySql? ."


To be more specific:

1.The Tables doesnt have same structure.

Hope it is clear.

So,all the Querie may be simple but please kindly explain me the proccess to do so.

Thanks in Advance.
SAM

Re: Transfer of data
 

select into

is your friend

Re: Transfer of data
 

Hi

Thanks for the reply ...I wrote a procedure which copies the data from one table to other but no idea regarding when and where it should be invoked in order to tansfer at the given timestamp.

Re: Transfer of data
 

if you need some help post your schema and what the timestamp requirements are

Re: Transfer of data
 

Hi,

Sorry For the delayed reply.

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

Table1:Schedule
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.

Re: Transfer of data
 

>>select into

I think it is used in SQL Server.
is it possible in Mysql?

Re: Transfer of data
 

event i believe is only only available in 5.1.6

select into with my sql is an insert statement with a select

insert into Out(recipient, Text)

select recipient, Text from Schedule where TimeToSend = curdate();

i would suggest timetosend be <= curdate(), you'll never get a match exactly on times most likely unless you are going by date only

Re: Transfer of data
 

Hi, Thanks fo rthe reply right now I odnt have nay problem with my statements..

yes u r right mysql.event is available for 5.1.6 or gretaer than that

I wrote a procedure schedule() in that proc i used the "insert into command " ..
when i created an event using

"create event transfer on schedule every 1 second
do call db.schedule();"

it works fine ... but i have a minor probvlem here ..
when my system reboots .. the event doesnt work automatically ..