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')
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)
-
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...