Re: automation question: How do I copy the data from one table to another table with a time stamp every night?

Chuck Barnett wrote: How do I copy the data from one table to another table with a time stamp every night? example: table A contains x,y,z. at midnight, I want to copy table A's contents to table B (B has same fields, just adds a date field) and reset x,y,z to zero. what do you

Re: automation question: How do I copy the data from one table to another table with a time stamp every night?

Thanks for replying. I know the SQL commands, I want to know how to automate the whole sequence. I've always written php pages that do the calls. I want to write a script to do it on the server as a cron job or something. thanks Chuck - Original Message - From: "Steve Ruby" [EMAIL

Re: automation question: How do I copy the data from one table to another table with a time stamp every night?

Chuck Barnett wrote: Thanks for replying. I know the SQL commands, I want to know how to automate the whole sequence. I've always written php pages that do the calls. I want to write a script to do it on the server as a cron job or something. Ahhh, pardon my confusion, since this the

RE: automation question: How do I copy the data from one table to another table with a time stamp every night?

if you've compiled php without apache support (separately from your normal php with apache support) but with mySQL then you can write php scripts that run from the command line. I usually keep a second php.ini for command line scripts because they can run long. This all could be put in a CRON