MySQL Forums
Forum List  »  Partitioning

Re: copying from unpartitioned to partitioned table
Posted by: Mattias Jonsson
Date: March 11, 2010 08:18AM

Are you sure you want to partition on phone number and cast it to integer?

1) cast a phone number to integer depends on the format of the phone number string (plus, dash, space characters may interfere with the cast...) and if you are sure this is what you want, then you should first normalize the strings to a format that can be converted to integer (note that an integer does not have leading zeroes.)

2) What queries do you intend to run on the table? if you do exact match (like 'select * from t where phonenum = '0800-...') then you can use KEY partitioning directly with varchar column.

So how do you use the table? (after answering that question it is easier to tell you how to partition your data...)
and what are you trying to accomplish by partitioning the data?

Options: ReplyQuote

Written By
Re: copying from unpartitioned to partitioned table
March 11, 2010 08:18AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.