Quoting Jerry Schwartz :
-Original Message-
From: Jacob Steinberger [mailto:trefal...@realitybytes.net]
I have a requirement to keep track of a set of data, and all changes
that might occur. In order to do this, for each field of the data set,
I've created a table that keeps track of the
>-Original Message-
>From: Jacob Steinberger [mailto:trefal...@realitybytes.net]
>Sent: Wednesday, August 25, 2010 8:36 PM
>To: mysql@lists.mysql.com
>Subject: Complicated SQL Query
>
>I have a requirement to keep track of a set of data, and all changes
>that mig
Inventions come from need.
Congratulations and thank you for sharing your science,
Its very interesting.
May be useful for other uses.
Claudio
On Aug 26, 2010 9:11 AM, "Jangita" wrote:
> On 26/08/2010 4:31 a, Jacob Steinberger wrote:
>> I found an answer without having to worry about complicated
On 26/08/2010 4:31 a, Jacob Steinberger wrote:
I found an answer without having to worry about complicated SQL
statements - it's more about managing the tables than the SQL.
Jacob
I usually just turn on binary logging, that way I have a record of
anything that changes in the entire database an
I found an answer without having to worry about complicated SQL
statements - it's more about managing the tables than the SQL.
Jacob
Quoting Jacob Steinberger :
I have a requirement to keep track of a set of data, and all changes
that might occur. In order to do this, for each field of the d
I have a requirement to keep track of a set of data, and all changes
that might occur. In order to do this, for each field of the data set,
I've created a table that keeps track of the version, the value, the
time the change was made, and a linking number that links all the
different tables
