New answers tagged

0

It seems like just the session id would be 'unique' for defining the User? And maybe a separate table would hold the multiple bell_mode values for each user? You have to think through the application to figure out what is "unique"; we cannot do it for you. CURDATE() is a date, not a datetime. NOW() is a datetime. CURDATE() < ring_date -- before ...


0

You have several issues that need to be addressed. ISSUE #1 : Index column order If you have to delete data by date, the the ring_date should be the first column in the index. ISSUE #2 : Index uniqueness The index should not be unique. Why ? If two or more ring events occur at the same time, the unique index prevents subsequent insertions after the first ...



Top 50 recent answers are included