mysql 分區表 的建立

建立完成的分區表

CREATE TABLE `employees` (
  `id` int(11) NOT NULL,
  `fname` varchar(30) DEFAULT NULL,
  `lname` varchar(30) DEFAULT NULL,
  `hired` date NOT NULL DEFAULT '1970-01-01',
  `separated` date NOT NULL DEFAULT '9999-12-31',
  `job_code` int(11) NOT NULL,
  `store_id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1
/*!50100 PARTITION BY RANGE (store_id)
(PARTITION p0 VALUES LESS THAN (6) ENGINE = MyISAM,
PARTITION p1 VALUES LESS THAN (11) ENGINE = MyISAM,
PARTITION p2 VALUES LESS THAN (16) ENGINE = MyISAM) */ |

 

/*!50100 注意這個
這是用來限制版本的，低於標示版本的會忽略此段

mysql> select /*!40100 now()*/;
+---------------------+
| now()               |
+---------------------+
| 2009-06-15 21:37:09 |
+---------------------+
1 row in set (0.00 sec)

mysql> select /*!50100 now()*/;
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 '' at line 1
mysql> select version();
+------------+
| version()  |
+------------+
| 4.1.18-log |
+------------+
1 row in set (0.00 sec)