Hi i’ve recently start doing some research on EDM. Different platform ( Desktop App , Mobile App, Web Mail ) for different product (Gmail , Yahoo , AOL….) will have different can & can’t do things. To have a clearer view of what i meant , you can check out this link https://www.campaignmonitor.com/css/ Since most […]
Mysql DB allowing old user from different IP with same grants
Firstly, We have to create a new user from different ip , so we have to run the below command. The first “Select” query is to get all column in user table and the thing we wanna replace is the Host ( the ip that client is going to connect from ). #User Table #To […]
Mysql Procedure creation
Procedure Creation Example MariaDB [stress]> DELIMITER ;; MariaDB [stress]> CREATE PROCEDURE ABC() -> BEGIN -> WHILE 1 -> DO -> SELECT COUNT(*) FROM stresstable; -> DO SLEEP(1); -> END WHILE; -> END;; MariaDB [stress]> DELIMITER ; MariaDB [stress]> CALL ABC(); Procedure Listing $ SHOW PROCEDURE STATUS; OR $ SELECT ROUTINE_SCHEMA,ROUTINE_NAME FROM information_schema.routines where routine_type = […]
Color Schemes ( Vim )
$ #ls -l /usr/share/vim*/colors To set it permanently go to ~/.vimrc, set color default
Javascript Get All Class element and convert it into array
var elems = Array.prototype.slice.call(document.querySelectorAll(‘.js-switch’)); Explanation: document.querySelectorAll(‘ClassName ID’) – Get All Class or id element and put into object Array.prototype.slice.call – Convert Object into Array Looping:- elems.forEach(function(html) { ### Your Code Here ### });
Gnome Terminal – ssh execute with command
gnome-terminal –command ‘ssh -t -p22122 julius@jumper.aims.tameko.co “tmux a”‘
Shell Scripting Accepting Argv , getops , checking , echoing
#!/bin/bash #getopts checking for argv and define it into variables #options that needs to receive parameter have to enter : after the option EG: f:u:d: #In This Example h does not accept parameter. it execute the case only while getopts u:d:p:f:h option do case “${option}” in u) USER=${OPTARG};; d) DATE=${OPTARG};; p) PRODUCT=${OPTARG};; f) FORMAT=$OPTARG;; h) […]
MysqlDump without locking Tables
# dumping data without lock table mysqldump -u[USER] -p[PASS] –skip-lock-tables –single-transaction –flush-logs –hex-blob –master-data=2 –max_allowed_packet=1G globe_sdp > globe_sdp_v2.sql