Hey there,
i have been messing around with MySQL for a little bit now. I have a
question about how i might could do something.
i am writing a database to track what a bunch of electric monitors are
doing.
the status of the monitor changes almost daily. i need access to each
monitor, when it
At 01:49 PM 7/2/05, nephish wrote:
i am writing a database to track what a bunch of electric monitors are doing.
the status of the monitor changes almost daily. i need access to each
monitor, when it changed, and i also need to track its history. Easy
enough. but if i update a row in a table,
@lists.mysql.com
Sent: Saturday, July 02, 2005 11:49 AM
Subject: offer a solution ?
Hey there,
i have been messing around with MySQL for a little bit now. I have a
question about how i might could do something.
i am writing a database to track what a bunch of electric monitors are
doing.
the status
much history you need to keep, you can periodically trim the table by
deleting all data older than N days (or hours, months, years).
- Original Message - From: nephish [EMAIL PROTECTED]
To: mysql mysql@lists.mysql.com
Sent: Saturday, July 02, 2005 11:49 AM
Subject: offer a solution
depending on what you use this information for, you might want to keep
two tables, one with the current information, and one of the history. it
would keep the current one relatively small, but allow for looking up
historical data if necessary.
nephish wrote:
Hey there,
i have been messing