troubleshooting Question

Filtering data for last date, getting all columns.

Avatar of KurtVon
KurtVon asked on
MySQL Server
4 Comments1 Solution1069 ViewsLast Modified:
I'm storing grid data in a database, but "journaling" each cell to allow retrieving the grid state at a particular time.  The initial storage uses the columns name, date, row, col, value.

To change a cell value I just insert a row with the row, col, and value set and date set to NOW().  To delete, value is set to NULL.

But to get the current cell data is proving too difficult.  I know I want to do something like:

SELECT row, col, value FROM journal WHERE name = ? GROUP BY row, col HAVING date = MAX(date)

but of course this won't work since the value column is not part of the GROUP BY.

I could get a value based on the date, but need to use the row and col values as well, and each row and column may have a different MAX(date).

I can't be the first person to try journaling data in MySQL, so a solution to the query or a pointer to teh right way to do this would be accepted.

Thanks for any help.
ASKER CERTIFIED SOLUTION
virmaior

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros