Why should the time be required to be a time period when the database queries the time date field?

question:
select * from table where created_at >
where is the problem? How to solve?

answer:
time writes dead,
closes, time opens, there must be closing time.

The

question is, why should it be a closed interval when querying this time field? It has to be a range?

I personally think it should look like this:
if this is a log table, the amount of data is tens of thousands of minutes. If there is no specified range, it is easy to select a time ten or 20 years ago to find out all of it, and then the result is too large and dies
. So, the use of time interval is to prevent the problem that the result set is too large

.

is this the truth? Or in mysql code, it would be better to have an interval


I don't understand what your problem is

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1ea7339-1e35.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1ea7339-1e35.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?