【闪电结贴】【50分求一SQL语句的含义】
0轰隆隆0 2007-07-03 04:42:23 UPDATE XXX SET TOTAL=TOTAL+1,MONTHS=(IF (MONTH(LAST_TIME)=MONTH(NOW()),MONTHS+1,1)),WEEKS=(IF (YEARWEEK(LAST_TIME)=YEARWEEK(NOW()),WEEKS+1,1)),DAYS=(IF (TO_DAYS(LAST_TIME)=TO_DAYS(NOW()),DAYS+1,1)),LAST_TIME=NOW() WHERE ZID='20070420'
嘿嘿,最好给点解释