Create a Date Folder on Windows
For categorizing daily backup files, we should make folders named with that date. In this post, we'll talk about how to create a folder by… Read More »Create a Date Folder on Windows
DATE
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
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)