Additions:
SET @d='2010-06-01';
Deletions:
Additions:
mysql> SELECT NOW() - INTERVAL 1 DAY;
+------------------------+
| NOW() - INTERVAL 1 DAY |
+------------------------+
| 2010-07-06 09:02:41 |
+------------------------+
+------------------------+
| NOW() - INTERVAL 1 DAY |
+------------------------+
| 2010-07-06 09:02:41 |
+------------------------+