MySQL Stored procedure – Execute query if table or Column exists

December 5, 2009

Well procedures mainly carried out working with information schema and it’s usage in stored procedure. Procedures are fairly simple and easy to understand. 1. Edit_table – following procedure executes queries to…

View Post

How to echo colored text in linux shell script

December 4, 2009

Having a colourful display on shell script is something that’d beautify your experience. Using colour text and echos will help you to highlight and distinguish the shell output on a…

View Post

MySQL master master replication monitor with php code

December 4, 2009

For monitoring replication we know a lot of tools and codes – but this one is different because I wrote it 😉 Well this is fairly simple php code for…

View Post

Using VLookup like Batch script to compare two excel / csv

November 24, 2009

Using Vlookup: I have two csv files; File1 has Id and Value Columns and File2 has Id. Problem: I need to compare both files and put respective values to File2…

View Post

bat – batch file to create formatted date time (ddmmyyyy) directory

November 18, 2009

In batch scripting, generating file and directory names with current date and time stamps can greatly enhance organization and workflow. This tutorial will walk you through various code snippets and…

View Post

Calculate MySQL Memory Usage – Quick Stored Procedure

November 16, 2009

In this post we will look into the MySQL memory utilization estimation or calculation based on the global variables. Using a simple stored procedure call you can get the memory…

View Post