From: Frank Bax (fbaxsympatico.ca)
Date: Sat Jul 02 2005 - 11:09:40 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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, i loose the old info. So i kinda
>cannot create a table referenced by a key of monitor number... i think
>that the easiest way, would be to create a seperate table for each monitor.

Add a column for "date changed" instead.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]