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
DATE
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 Select Today's Data in MySQL (2/3)
How to Select Current Week's Data in MySQL (1/3) There are various date functions to resolve different situations in MySQL. Here I introduce several ways… Read More »How to Select Today's Data in MySQL (2/3)