The script executes MySQL query for half an hour corresponding data

SELECT
COUNT (logb.id)
From
Rm_operate_log
WHERE CONCAT (
Date_format (create_date, '%y%m%d%h-'),
IF (
Date_format (create_date, '%i ') > 30,
1,
0
)
) = CONCAT (
Date_format (now (), '%y%m%d%h-'),
IF (Date_format (now (), '%i ') > 30, 1, 0)

)

The server has a script that fetches data from the database every 30 minutes and then sends a push

1.date_format (create_date, '%y%m%d%h-') query the time format of the create_date in the library ' Month Day-'

2. Date_format (create_date, '%i ') > 30,
1,
0
The time format of the create_date in the query library is ' minutes ' if greater than 30 is 1 otherwise 0

3. Use Concat () to connect two strings together

4 then compare to the current time

The above describes the script for half an hour to perform MySQL query the corresponding data, including the content, I hope to be interested in PHP tutorial friends helpful.

