Mysql automatic job or trigger ?

[veledrom]

Hi,

I have "Balance" table that is shown below.

Table :Balance
todaysDate/openBalance/closeBalance
------------ --------------- --------------
2008-07-24 250000 100000

Above record will be inserted into next row as it is at 10:00pm.

How do i do this?

Thanks

[tesuji]

By tricky triggers, as you may have already figured out.

[chaosprime]

I do not believe that is actually the case. MySQL has no concept of triggering on a time of day (which is to say, scheduling). If you want something to happen at 10:00 PM, you need to use whatever scheduling support your OS provides (cron, on Unix systems, Scheduled Tasks on Windows, etc.) to run a job at 10:00 PM.