The following is examples of SQL avaiable in MySQL and MariaDB
# 1 month ago
NOW() - INTERVAL 1 MONTH
# 3 months and 7 days ago
NOW() - INTERVAL 3 MONTH -INTERVAL 7 DAY
# Specify hour, minute, second
DATE_FORMAT(now() - interval 1 year - interval 3 month, '%Y-%m-%d')
This blog moved to medium->https://medium.com/@cocoamaemae
Regarding TIPS about IT technologies or OSS which I created.
Thursday, December 22, 2016
Wednesday, December 14, 2016
How to use du
What's du?
Reports the size of directory trees
Basic syntax
Reports the size of directory trees
Basic syntax
du <options> <file or directory name>
options
# Show capacity
-h
# Show amount of files or directories
-h
# Show amount of files or directories
-s
# Specify tree depth
--max-depth
e.g.
# Specify tree depth
--max-depth
e.g.
# Show capacities from root path tree
du -sh /
du -sh /
Subscribe to:
Posts (Atom)
Front End Development Tools
TaskRunner Tool executing multiple tasks by only one execution. Tasks are like CSS preprocessor, Transpire, Module Bundler, etc... e.g. ...
-
What is partitioning? The structure which divides one table data to multiple data. When not using partitioning, one table data is aggrega...
-
It is general to create multiple branches and manage them parallel when we do the development by using git. Multiple branches should be mer...
-
What's URL encode? URL can be sent only ASCII characters over internet. When doing http request with query parameters, query parameter...