Member Avatar for 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

  • 3 Contributors
  • 2 Replies
  • 122 Views
  • 5 Days Discussion Span
  • Latest Post Latest Post by chaosprime
Member Avatar for tesuji

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

Member Avatar for 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.

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.