查询计数器

查询计数器

原版：

curdate()当前日期，无时间

selectcurdate() - interval (a.a + (10 * b.a) + (100 * c.a) + (1000 * d.a) ) day as dayfrom(select0 as aunion allselect1union allselect2union allselect3union allselect4union allselect5union allselect6union allselect7union allselect8union allselect9) as across join (select0 as aunion allselect1union allselect2union allselect3union allselect4union allselect5union allselect6union allselect7union allselect8union allselect9) as bcross join (select0 as aunion allselect1union allselect2union allselect3union allselect4union allselect5union allselect6union allselect7union allselect8union allselect9) as ccross join (select0 as aunion allselect1union allselect2union allselect3union allselect4union allselect5union allselect6union allselect7union allselect8union allselect9) as d 

查询结果：

从今天开始之前的每一天

把查询的日期换成*你会发现：

变成了1的计时器