How to move records from one table to another table using a specified time limit eg:60 days old record should be moved from one table to another table.
The better way to copy records from one to another is . This assumes that your table has a column to store the created date. The syntax might slightly differ from database to database.
Sudheer Bhat wrote:The better way to copy records from one to another is . This assumes that your table has a column to store the created date. The syntax might slightly differ from database to database.
But what exactly is the created date.both the table has same column name.