How to pull out all records from the database for the last 30 seconds, taking into account the user ID?

Question

MySQL

Hello everyone!)

Guys, I know that the question is very simple and damn it, very stupid, but I even earned so much that I got lost in 3 pine trees)

The task is simple, you need to select all records from the database, taking into account the user ID for the last 30 seconds and calculate their number, I write this request

SELECT COUNT(*) FROM count_check WHERE id=555334444444 AND created_at >= (now() - interval 30 second)

and it always returns zero. I tried to use the DATE_SUB () function, everything is the same.

Please tell me what am I doing wrong? Something strange, thanks in advance

Answer 1

Execute the query SELECT NOW(); and compare with the time of the last records, otherwise you can create with one date / time zone, and now () produces a different date? And check if those columns are needed in the query)