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

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

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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.