Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2009
    Posts
    18

    Unanswered: Add partition on exising table ?

    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
    Last edited by bh_hensem; 04-08-10 at 01:53.

  2. #2
    Join Date
    Sep 2009
    Location
    San Sebastian, Spain
    Posts
    880
    Partition support is only from 5.1 onwards.
    Ronan Cashell
    Certified Oracle DBA/Certified MySQL Expert (DBA & Cluster DBA)
    http://www.it-iss.com
    Follow me on Twitter

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •