I need to transfer data between tables within a database
-
Hi all, I am using MySQL 5.0 database. I need to transfer the data from one table to another within a mysql database based on the particular time interval. Is it possible to transfer data among the tables a database automatically. Please help me. Thanks in Advance, J. Mohan
J. Mohan
-
Hi all, I am using MySQL 5.0 database. I need to transfer the data from one table to another within a mysql database based on the particular time interval. Is it possible to transfer data among the tables a database automatically. Please help me. Thanks in Advance, J. Mohan
J. Mohan
Hmm I don't know about MySQL but most databases have no idea what time is. To do this you need a running process (to keep track of the time) and to periodically execute the transfer method. In SQL Server I would set it up as a job. If there is no concept of a job in MySQL then you may need to write an external process to do the scheduling for you.
Never underestimate the power of human stupidity RAH