sethbeckerman5 Staff asked 4 years ago
The logins of each user are stored in the table of the mysql database 5.5.46 version
Each user has three minutes to logout manually.
Each single logout is stored in the same table .
I need to update on the table the column with value 'N' when the user log out manually within the expected three minutes.
Example for CIRICILLS
Because the time difference from first login and next manually logout for CIRICILLS, is less than the three minutes.
Any suggestion?
https://www.db-fiddle.com/f/5T3qr61DP2qtDDaWUnpBgA/4
View on Stack Overflow