MrClemRkz Knowledge Base

Posts

Switch between git commit versions

$ git reset --hard <SHAsum of your commit> You can also try $ git reset --hard HEAD #your current head point or $ git reset --hard HEAD^ #your previous head point

How to clean untracked file

Revert changes to modified files. terminal $ git reset --hard Remove all untracked files and directories. (`-f` is `force`, `-d` is `remove directories`) terminal $ git clean -fd For Dry run and see which files be removed first $ git clean -nd

create new branch from a remote branch

Command $ git checkout -b <branch-name> <remote-repo-name>/<remote-repo's-branch-name>

pretty json format on terminal

For CURL $ curl <url> | python -m json.tool Likewise you may use any output by command appending the terminal command $ <terminal command to output json code> | python -m json.tool

Fix for 'this is incompatible with sql_mode=only_full_group_by'

In order to run sql scripts which is not compatible with the sql_mode=only_full_group_by, we need to remove it from sql_mode. Globally mysql> SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY','')); Logged Session only mysql> SET SESSION sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));

convert unix timestamp to datetime in MySQL

Example mysql> SELECT FROM_UNIXTIME(1548261800);