Thanks to antville.org
Wednesday, 16. May 2018
mysql and shell command

date -d"-1 day ago" +'%b%d'

equals to

mysql -Bse"select date_format(date(date_add(now() , interval 1 day)),'%b%d')"

... Comment

Online for 5870 days
Last modified: 9/10/18 7:44 AM
Status
Youre not logged in ... Login
Menu
... Home
... Tags

Search
Calendar
September 2018
SunMonTueWedThuFriSat
1
2345678
9101112131415
16171819202122
23242526272829
30
August
Recent updates
Google Input tools Google suddenly
stopped download of Input Tools package without giving any reason....
by shantanuo (9/10/18 7:44 AM)
Python objects and methods Here
are important python objects and their methods int __mul__, __add__,...
by shantanuo (8/18/18 3:11 PM)
JSON to DF Here is
how to read a JSON file into pandas dataframe. import...
by shantanuo (8/8/18 1:12 PM)
managing servers using python Fabric
is a high level Python library designed to execute shell...
by shantanuo (8/4/18 10:01 AM)
backup mysql users It is
easy to backup mysql users - wget percona.com/get/pt-show-grants; perl pt-show-grants
by shantanuo (5/20/18 3:42 PM)
About python 1 everything is
an object (class instances) 2 methods depends upon class of...
by shantanuo (5/20/18 2:52 PM)
mysql and shell command date
-d"-1 day ago" +'%b%d' equals to mysql -Bse"select date_format(date(date_add(now() ,...
by shantanuo (5/16/18 7:47 AM)
Preserving comments in Stored Procedure
You can write multi line comments in a stored procedure...
by shantanuo (5/12/18 12:56 PM)
Custom slack command Here are
5 steps to add any API to your slack channel....
by shantanuo (4/25/18 6:59 AM)
stack bookmarklet This bookmarklet will
help to quickly access stack pages linking to current page...
by shantanuo (1/10/18 10:47 AM)
Manage S3 like rsync ####
create bucket aws s3 mb s3://johntest123/ #### rsync all files...
by shantanuo (12/22/17 12:04 PM)
apache docker container issues If
apache docker container does not start then make these changes......
by shantanuo (11/10/17 3:00 PM)
Install aws client on centos
If pip is not installed, then the following command will...
by shantanuo (10/26/17 9:51 AM)
Managing Amazon keys Use this
command to convert private key to public key. ssh-keygen -y...
by shantanuo (10/9/17 7:04 AM)
percona utility We can re-create
mysql users using the percona utility. wget percona.com/get/pt-show-grants chmod 777...
by shantanuo (9/6/17 8:22 AM)
mail merge separate file per
record Microsoft Word has an excellent feature called Mail-Merge. If...
by shantanuo (7/6/17 12:09 PM)
find dead processes The 8th
column of ps aux command will list the status of...
by shantanuo (5/28/17 7:39 AM)
Amazon Web Services Here are
some of the important Amazon products to use. cloudTrail...
by shantanuo (5/10/17 11:35 AM)
Self signed security certificate http://www.thegeekstuff.com/2009/07/linux-apache-mod-ssl-generate-key-csr-crt-file/
openssl genrsa -out 34.195.94.88.key 1024 openssl req -new -key 34.195.94.88.key...
by shantanuo (1/16/17 8:02 AM)
docker and aws Before starting
docker daemon, add the aws credentials. vi /etc/init/docker.override env AWS_ACCESS_KEY_ID=...
by shantanuo (11/23/16 3:01 PM)
Turn off Windows Updates in
Windows 10 There is no option to turn off Windows...
by shantanuo (10/30/16 2:43 PM)
RSS extension for chrome RSS
Subscription Extension (by Google) is a must have chrome extension...
by shantanuo (7/9/16 7:28 AM)
use putty for presentation Config
- Change settings... - Window - Colours - Use system...
by shantanuo (5/23/16 1:26 PM)
docker command examples # options
for running docker docker run -d --name abcd2 -p 23:23...
by shantanuo (5/21/16 11:04 AM)

RSS feed

Made with Antville
Helma Object Publisher