How to transfer the data of certain users from the adjacent table daily?

Question

PHP

There are 2 tables: name1 and name2
At the end of the day, you need to copy the data of the login, pass fields from the name1 table to the name2 table into the login2, pass2 fields

Answer 1

http://blog.nagaychenko.com/2009/11/30/scheduler-and...
the very first link in google..

Answer 2

cron

Answer 3

Not quite familiar with MySQL, but on an Oracle base, I would create a trigger that actually inserts data from table 2 into table 1, and then clears table 1. This trigger would be stuffed into Job.