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
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
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