MySQL Partition by String ColumnNovember 15, 2015December 15, 2022You 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
How to Resolve "Warning: date(): It is not safe to rely on the system's timezone settings"August 30, 2013November 28, 2022Warning: 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)July 24, 2013November 25, 2022How 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)