How To Control Output Formatting Via The MySQL Shell CLI

Author: , May 26th, 2021

-N: No column headers -B: Batch mode – use tabs as field separators https://dev.mysql.com/doc/mysql-shell/8.0/en/mysql-shell-output-formats.html Multiple Formats Available: Table Format – use –result-format=table, alias –table Tab Separated Format – use –result-format=tabbed, alias –tabbed Vertical Format – use –result-format=vertical, alias –vertical JSON Format Output – use –result-format=VALUE, alias –json[=pretty|raw|off] VALUE may be one of: json or […]

How To List Running AWS Instances in all Regions Sorted by LaunchTime and Email in a Monospaced Font

Author: , July 1st, 2019

How To Reformat or Re-indent Files in VIM

Author: , January 11th, 2019

In the normal vim mode, typing gg=G will reindent the entire file. == will re-indent just the current line. http://vim.wikia.com/wiki/Fix_indentation

How To Convert UNIX Timestamps to Date using PHP CLI

Author: , August 15th, 2015

For a quick visual check to see what the human-readable date is based on a UNIX timestamp integer: php -r ‘print date(“r”,1483228799);’ php -r ‘print strtotime(“1 Jan 2015”) – 1;’

How To Round And Format Numbers In JavaScript

Author: , September 23rd, 2012

How To Format Numbers Using PHP Or Smarty

Author: , December 1st, 2011

PHP number_format($number, 2, ‘.’, ‘,’); SMARTY {$number|number_format:2:”.”:”,”}

How To Format The Number Of Decimal Places In Perl

Author: , October 10th, 2011

Outputs: 123.450

How To Round Up A Number In Perl

Author: , October 10th, 2011

To round up to the nearest 5:

http://search.cpan.org/dist/Math-Round/Round.pm To round up to the nearest 1: Cross-posted from PerlMonks: