Re: Partitioning by Date

[Jonathan Stephens]

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

MySQL Dev Zone
MySQL Server Documentation
Oracle