Mysql automatic job or trigger ?

Expand Post »

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

veledrom

Reputation Points: 38

Solved Threads: 0

Master Poster

Offline

724 posts
since Apr 2008

Permalink

Jul 25th, 2008

Re: Mysql automatic job or trigger ?

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

tesuji

Reputation Points: 158

Solved Threads: 98

Master Poster

Offline

720 posts
since Apr 2008

Permalink

Jul 29th, 2008

Re: Mysql automatic job or trigger ?

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.

chaosprime

Reputation Points: 18

Solved Threads: 4

Light Poster

Offline

46 posts
since Jul 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MySQL Forum Timeline: setting up mysql db on new server

Next Thread in MySQL Forum Timeline: MySQL query- Error

DaniWeb Message

Cancel Changes

User Name
Password