Код: Выделить всё
DELETE FROM t_name WHERE t_stamp = NOW()-INTERVAL 1 WEEK;Код: Выделить всё
SELECT @t:=NOW() - INTERVAL 1 WEEK;
DELETE FROM t_name WHERE t_stamp < @t;Код: Выделить всё
mysql> SELECT NOW(), SUBDATE(NOW(), INTERVAL 1 WEEK);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'WEEK)
' at line 1
mysql> SELECT NOW(), SUBDATE(NOW(), INTERVAL 14 DAY);
+---------------------+---------------------------------+
| NOW() | SUBDATE(NOW(), INTERVAL 14 DAY) |
+---------------------+---------------------------------+
| 2008-08-29 12:33:25 | 2008-08-15 12:33:25 |
+---------------------+---------------------------------+
1 row in set (0.00 sec)
mysql>Код: Выделить всё
mysql> SELECT version();
+------------+
| version() |
+------------+
| 4.1.15-max |
+------------+
1 row in set (0.00 sec)
mysql>Код: Выделить всё
mysql> select @t:=subdate(now(),interval 1 day);
+-----------------------------------+
| @t:=subdate(now(),interval 1 day) |
+-----------------------------------+
| 2008-08-28 10:31:17 |
+-----------------------------------+
1 row in set (0.00 sec)
mysql> select @t;
+---------------------+
| @t |
+---------------------+
| 2008-08-28 10:31:17 |
+---------------------+
1 row in set (0.01 sec)
mysql> delete quick from t_name where t_stamp < @t;Код: Выделить всё
explain select * from t_name where t_stamp < 1;Код: Выделить всё
mysql> explain select * from rejects where d_time < 1;
+----+-------------+---------+------+---------------+------+---------+------+--------+-------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+---------+------+---------------+------+---------+------+--------+-------------+
| 1 | SIMPLE | rejects | ALL | NULL | NULL | NULL | NULL | 528887 | Using where |
+----+-------------+---------+------+---------------+------+---------+------+--------+-------------+
1 row in set, 1 warning (37.73 sec)
mysql>