Posts
Create a table like another table or from a select query
There are some cases where we need to create a table similar or exactly same as another table. The easiest and best way is use create table along with additional parameters. We can create a table similar to another table without data and with data. C …
Find Invisible Users In Gmail
Finding who is invisible is something that I always wanted to do.It’s always fun to ping a person who feels none can see him/her online. While studying XMPP protocol I found out that even when the person is offline the chat client knows that person is onli …
“Send To” in Linux for Nautilus
It’s been a common practice among the windows users to right click and search for “Send To” option when a file needs to copied to the USB or any other Drive. Why spare me, even i used to do this while using windows, when to my astonishment i found that th …
Tab Feature in Vim
Vim is one of the simplest looking but most powerful editor I have seen. So thought of listing a few interesting one that I came across. Tab Opening of Files. There are two methods of starting files in tabs. By opening vi the files you want to op …
Simplest way to remove trailing zeros of decimal numbers
This is a simple method I found to remove or strip trailing zeros of a decimal number. The function accepts the decimal number and return the trimmed value back. It removes all the redundant zeros in the number after the decimal point and if no number othe …
Customizing Mysql Prompt For multiple Servers
If you are using mysql regularly on multiple servers its really useful to have the promt in mysql to show something more than mysql>. It would be useful if it showed the username,hostname, current database and things like that. So how to do this. …
Restoring the Grub after reinstalling Windows
After reinstalling windows or fixing MBR(Master Boot Record) you always loose your grub and you cannot boot to your linux. So this post is about the methods of restoring the grub. There are three methods I use. I will explain all three. All three meth …
Generate Date from a range in Mysql and pad the results where no date is present
If you want to generate dates, MYSQL doesn’t have a range function, so I wrote a work around for the same. So how it works is I have reused a code to generate numbers from my previous post. So I added date function to that query and reduce the generated …
Recent Comments