Add partition on exising table ?

bh_hensem · #1 (**permalink**) 04-07-10, 22:56

Hi..

How to alter my existing table and add partition by key ?.

Below is my query:-

Code:

alter table packextra_trans2 
partition by key ('JobTicketID','FieldID1','FieldID2','FieldID5','FieldID9')
partition 5 (
partition 'p0_jobid',
partition 'p0_fid1',
partition 'p0_fid2',
partition 'p0_fid5',
partition 'p0_fid9'
);

This is my MYSQL version: 5.0.51a

is it the partition support for that version?

Thank you,
Baharin

it-iss.com · #2 (**permalink**) 04-15-10, 05:48

Partition support is only from 5.1 onwards.

Internet Services

Web Development

Digital Marketing

Consumer Tech