This blog moved to medium->https://medium.com/@cocoamaemae

Thursday, December 22, 2016

How to create date SQL by MySQL or MariaDB

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

Wednesday, December 14, 2016

How to use du

What's du?
Reports the size of directory trees

Basic syntax
du <options> <file or directory name>


options

# Show capacity
-h

# Show amount of files or directories
-s

# Specify tree depth
--max-depth

e.g.
# Show capacities from root path tree
du -sh /

Front End Development Tools

TaskRunner Tool executing multiple tasks by only one execution. Tasks are like CSS preprocessor, Transpire, Module Bundler, etc... e.g. ...