php mysql 新增行_PHP MYSQL检测是否添加了新行

这很难说，但根据你的评论...我的参考日期是1个月的间隔......你可能正在寻找这样的东西

SELECT id, client_name, new_count, total_count

FROM

(

SELECT id, client_name

FROM clients

WHERE date_added BETWEEN CURDATE() - INTERVAL 1 MONTH AND CURDATE()

) c CROSS JOIN

(

SELECT

(

SELECT COUNT(*) new_count

FROM clients

WHERE date_added BETWEEN CURDATE() - INTERVAL 1 MONTH AND CURDATE()

) new_count,

(

SELECT COUNT(*) total_count

FROM clients

) total_count

) t显然，您可以在此查询中轻松更改CURDATE()与过去的任何其他参考日期，并获得该日期的结果。

让我们假设您有以下示例数据

+------+-------------+------------+

| id | client_name | date_added |

+------+-------------+------------+

| 1 | ABC | 2013-05-13 |

| 2 | XYZ | 2013-06-13 |

| 3 | EFG | 2013-06-13 |

| 4 | HIJ | 2013-08-11 |

+------+-------------+------------+今天是2013-08-13然后查询的输出将是

+------+-------------+-----------+-------------+

| id | client_name | new_count | total_count |

+------+-------------+-----------+-------------+

| 4 | HIJ | 1 | 4 |

+------+-------------+-----------+-------------+