MySQL Forums
Forum List  »  Partitioning

Re: Partitioning by Date
Posted by: Jonathan Stephens
Date: January 19, 2007 05:29AM

I doubt such a change will appear in 5.1. However, I can tell you that TIMESTAMP(14) will be gone in MySQL 5.2.

Why not convert the TIMESTAMP(14) columns to DATETIME columns and then use triggers to set the values when rows are inserted or updated? The ALTER TABLE won't change any of your existing data, those columns will still be updated when necessary, and you'll be able to leverage partition pruning.

And you'll have to alter that table definition for the next major version of MySQL in any case. Might as well go ahead and get it over with. :)

Jon Stephens
MySQL Documentation Team @ Oracle
Orlando, Florida, USA

MySQL Dev Zone
MySQL Server Documentation

Options: ReplyQuote

Written By
November 10, 2006 01:19AM
November 11, 2006 02:13AM
January 18, 2007 11:53PM
Re: Partitioning by Date
January 19, 2007 05:29AM

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.