mysql 如何按周进行分区？

表中有DATE或TIMESTAMP字段,我想按照该字段每周一个分区。如何做到？

---

SQL code:
mysql> CREATE TABLE netxuning (
-> id INT NOT NULL,
-> mydate DATE
-> )
-> PARTITION BY RANGE (YEARWEEK(mydate)) (
-> PARTITION p0 VALUES LESS THAN (200901),
-> PARTITION p1 VALUES LESS THAN (200902),
-> PARTITION p2 VALUES LESS THAN (200906),
-> PARTITION p3 VALUES LESS THAN (200953)
-> );
Query OK, 0 rows affected (0.16 sec)

mysql>

---

引用

你可以用 YEARWEEK()  来分区

如果字段是时间戳呢？

YEARWEEK(from_UNIXTIME(1261555175, '%Y-%m-%d')); //这样搭配能不能用来分区？

---

引用

引用 1 楼 acmain_chm 的回复:
你可以用 YEARWEEK()  来分区


如果字段是时间戳呢？

YEARWEEK(from_UNIXTIME(1261555175, '%Y-%m-%d')); //这样搭配能不能用来分区？

试了一下，不行：
SQL code:

mysql> CREATE TABLE netxuning (
-> id INT NOT NULL,
-> mydate TIMESTAMP
-> )
-> PARTITION BY RANGE (YEARWEEK(from_UNIXTIME(mydat