Dynamic Mysql?

[Nusiance-Value]

Im kind of new to mysql and only know how to create standard tables and don't know where to look for the problem that I have.

I am looking to have a column in a table that will accumulate the results from another column every morning at 9 o'clock.

Is it possible to have mysql to do this on its own? Or would I need to run a php script from the server or a perl script?

[steve8557]

MySQL does not have the facility (yet) for triggers so yu'll need to run a script to populate the table.

You may be able to run a chron job on the linux server to automatically update the table or you could call a php script yourself each Monday.

Not much help but I hope that points you in the right direction

Steve

[Nusiance-Value]

Thanks.

I thought that if I use a php script then I can use windows task manager to run the script, but this seems a bit of a shabby way of doing it. I think it might be time to learn how to use perl :rolleyes:

[tomhath]

Perl vs php has nothing to do with it. You can use either one for scripting from a command line (check the Articles section of this site for how to do it with php).

[Nusiance-Value]

Oh, wow!!
I didn't know that could be done 🙂
Thanks, I'll check it out...