Tag Info

New answers tagged


Your question is somewhat like a question I answered back on Sep 06, 2013 : mySQL for analytics and updating same row In that answer, I recommended the following Adding a third column to the table to represent a slot Select an arbitrary value for the number of slots Making a composite PRIMARY KEY hour boundary slot number Doing an INSERT with ON ...

Top 50 recent answers are included