MySQL Partition by String Column
You might have known that LIST, RANGE, and HASH partitions all refuse to accept VARACHAR column as the native partition key. mysql> alter table locations… Read More »MySQL Partition by String Column
DateTime
More CURRENT_TIMESTAMP Columns?
If 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 "Warning: date(): It is not safe to rely on the system's timezone settings"
Warning: date() After intalling a newer version of PHP package, you might get this warning message in the client's browser: Warning: date(): It is not… Read More »How to Resolve "Warning: date(): It is not safe to rely on the system's timezone settings"
How to Subtract Time from Now in PHP
Subtract Date Time There are 2 ways to subtract a time interval from a date or add to it in PHP: Use Function strtotime Using… Read More »How to Subtract Time from Now in PHP