More CURRENT_TIMESTAMP Columns?April 27, 2014December 5, 2022If you are a senior MySQL developers, you have already known there's at most one column can use CURRENT_TIMESTAMP as the default value. For example,… Read More »More CURRENT_TIMESTAMP Columns?
How to Resolve ERROR 1697 (HY000): VALUES value for partition must have type INTSeptember 3, 2013December 8, 20222 CommentsERROR 1697 (HY000) Using a date or int column as a partition key is a lot easier than using a timestamp column in MySQL. Because… Read More »How to Resolve ERROR 1697 (HY000): VALUES value for partition must have type INT