Sometimes you may need to replace multiple strings & patterns in column in MySQL. Here is how to do regular expression replace in MySQL.
How to Get Digits from String in MySQL
Sometimes you may need to extract number from string or numerical value from string in MySQL. Here is how to get digits from string in MySQL.
How to Use SCP with PEM File (SSH Key)
Sometimes you may need to copy file to EC2 instance without password using SCP. Here is how to use SCP with PEM file (SSH key).
How to Ignore SSL Certificate Errors in cURL
cURL works with SSL certificate for HTTPS URLs. Here is how to ignore SSL certificate errors in cURL.
How to Get Creation Date for File & Directory in Linux
Sometimes you may need to get creation date for file & directory in Linux. Here are the steps to do it.
How to Delete Iptables Rules
Sometimes you may need to delete iptables rules and chains. Here are the steps to delete iptables rules in Linux.
How to Use Rsync With SSH Key
Sometimes you may need to use rsync with SSH key. Here are the steps to do it using public key generation.
How to Run Python Scripts in Sequence
How to Download Attachment from Gmail Using Shell Script
Sometimes you may need to download attachment from Gmail in Terminal. Here is how to download Gmail attachment using shell script.
How to Do Google Search from Terminal
Sometimes you may need to do Google search from Linux terminal. Here are the steps to do it using Googler.