MySQL Forums
Forum List  »  Partitioning

Re: Cannot create partition with ASCII function.
Posted by: Phil Hildebrand
Date: May 02, 2008 10:39AM

There are only a few functions currently you can use with partitioning:

ASCII isn't on the list.

In your case (depending on the complexity of the project), it might make more sense to break out the Job Code to another table so you end up with a job_id (integer) in the employee table that logically references the new job_code_type table or something, then you could do it.

Depending on your queries as well, it might make sense to partition employee's on store_id instead of job_code (depending on your reason for wanting to partition on job_code)

Options: ReplyQuote

Written By
Re: Cannot create partition with ASCII function.
May 02, 2008 10:39AM

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.