Srijith Unplugged » Search Results » mysql-client-prompt-customisation

Important MySQL DBA Interview Questions

Srijith R — Tue, 28 Jun 2011 06:58:55 +0000

Here are a few sets of interview questions expected for MySQL DBA position.These are compilation of the usual questions from various DBA texts: What is Log Switch? - The point at which ORACLE ends writing to one online redo log file and begins writin ...

Installing Django on Dreamhost

Srijith R — Thu, 09 Jun 2011 08:27:36 +0000

Installing Django in Dreamhost and getting it to run wasn't straight forward at-least to me. There was lot of issues such as python bin directory not accessible as its shared and so. So the initial step in this to setup python yourself so that you can ...

Get the nth Word from a text field in mysql

Srijith R — Fri, 15 Oct 2010 09:28:01 +0000

I had a requirement to get the nth word out of a string and sort or order by the same. This is used when the text is stored in a purticular format and you would want to order it according to that or group it or so on. So how is it done? We do it us ...

Display row number in Mysql Select Query

Srijith R — Tue, 17 Aug 2010 22:54:07 +0000

How many times did want to have the row number or the position of the row in the selected query? I had many cases where I needed this feature. I needed the feature for printing the rank of a person where each row is the mark of the person. So lets see how ...

BSNL Dataone Auto Downloader

Srijith R — Sun, 15 Aug 2010 21:41:43 +0000

Bsnl(India) provides an account that has 2am to 8am unlimited download. It was not easy to wake up at 2am and switch on the computer and sleep again. So I tried to find a method to switch on the computer automatically at 2am and download and shutdown at 8a ...

Adding RedHat DVD as Repository

Srijith R — Thu, 12 Aug 2010 19:08:23 +0000

When we try out a new linux OS its always a pain to download and install all the software and add packages we needs on that. Its even worse if you don't have an unlimited connection. But actually most of the software we need is already there in the CD/DV ...

Find Invisible Users In Gmail

Srijith R — Wed, 11 Aug 2010 05:03:38 +0000

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 ...

Customizing Mysql Prompt For multiple Servers

Srijith R — Sun, 08 Aug 2010 02:11:33 +0000

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

Srijith R — Sat, 07 Aug 2010 14:05:28 +0000

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

Srijith R — Sun, 25 Jul 2010 10:35:03 +0000

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 ...