Posts
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 …
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 …
Generate 1 to 1000 in mysql
Sometimes its necessary to have thousand rows to join or generate new values, we need to get the thousand rows first. For this I used union of numbers 0-9. I have joined four of these to get to four digit values. So here is the code: [sql]SELECT @ro …
Check the port in which the Mysql is running on
Mysql can be configured to run other ports other than the default port (of 3306). So what will you do when you need to find the port on which a mysql server runs on. If you don’t have access to the server files and can access the server only using the mysq …
Recent Comments