RE: Mysql Table partitioning

2007-11-29 Thread gunwant walbe
08:13:09 | | 5 | 1987-11-28 08:13:09 | ++-+ -Original Message- From: gunwant walbe [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 28, 2007 12:21 AM To: joe; mysql@lists.mysql.com Subject: RE: Mysql Table partitioning Thanks Joe, I have edit

Mysql Table partitioning

2007-11-27 Thread gunwant walbe
hi all, I want to know some information about table partitioning. consider following script create table `customers`( `CustomerID` varchar(40) not null, `TimeCreated` DATETIME not null default 0, `TimeModified` datetime not null default 0, `isActive` tinyint not

RE: Mysql Table partitioning

2007-11-27 Thread gunwant walbe
problem that you will see is the PK and unique keys in partitioning have to have the partition key as part of the index. So your PK would have to be CustomerID, TimeCreated -Original Message- From: gunwant walbe [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 27, 2007 5:23 AM