Mysql automatic job or trigger ?

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 426,011 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 1,611 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our MySQL advertiser: Programming Forums

Thread Tools Display Modes

Views: 413 | Replies: 2

•

Join Date: Apr 2008

Posts: 196

Reputation: veledrom is an unknown quantity at this point

Rep Power: 1

Solved Threads: 0

veledrom

Offline

Junior Poster

Mysql automatic job or trigger ?

Jul 24th, 2008

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

•

Join Date: Apr 2008

Posts: 295

Reputation: tesuji is an unknown quantity at this point

Rep Power: 1

Solved Threads: 41

tesuji

Offline

Posting Whiz in Training

Re: Mysql automatic job or trigger ?

Jul 25th, 2008

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

Information is moving—you know, nightly news is one way, of course, but it's also moving through the blogosphere and through the Internets. I promise you I will listen to what has been said here, even though I wasn't here. Ann and I will carry out this equivocal message to the world. I'm the master of low expectations.

•

Join Date: Jul 2008

Location: New Jersey

Posts: 46

Reputation: chaosprime is an unknown quantity at this point

Rep Power: 1

Solved Threads: 2

chaosprime chaosprime is offline

Offline

Light Poster

Re: Mysql automatic job or trigger ?

Jul 29th, 2008

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.

Chaos
Lost Souls: text based RPG
MUDseek: MUD gaming search