MySQL Pull Data By Second

Comments (0)

Views (153)

Hello, if we want to pull data per second from mysql database, we can use methods like the following. Assuming that the column name of the section where we keep the dates is the date, a sql code like this will work.

select * from tableName
where TIMESTAMPDIFF(SECOND, date, now()) > 30;

select * from tableName
where date > (now() - INTERVAL 30 SECOND);

When you are stuck while you are coding or when you need to relax yourself comment section is waiting for you. Ask what you don't know, answer what you know !