RE: Complicated SQL Query

2010-08-26 Thread Jacob Steinberger
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

RE: Complicated SQL Query

2010-08-26 Thread Jerry Schwartz
>-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 might occur. In order to do thi

Re: Complicated SQL Query

2010-08-26 Thread Claudio Nanni
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

Re: Complicated SQL Query

2010-08-26 Thread Jangita
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

Re: Complicated SQL Query

2010-08-25 Thread Jacob Steinberger
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