Posts

Display row number in Mysql Select Query

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

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 …

Script for Auto Copying of Cds/Dvds

Here is a script that i created for automatically copying all the files in cd to a folder and ejecting and waiting for the next cd. So here is how it works. You need to change the folder names and paths accordingly. And the shell script as [shell]  …

Display Reminders In Gnome Panel

It was a long standing requirement of mine to create a reminder software or something which can keep me reminding of things as I always keep forgetting things. So I made a reminder that displays my reminders on the Gnome Panel. It looks something like thi …

Copy in Linux with Ui

The program here is an UI for cp command. I have used cp in the background but over that I am just monitoring the files copied and speed of copying. It’s not a perfected program. It’s quick one but works fine. Execution: Create a file named copy and ins …

Automatic Desktop Wallpaper Changer for Linux

I have a lot of wallpaper that I wanted to switch automatically. After a lot of search i found that there a command way to control all the gnome settings. So I the command I used is “gconftool-2″. So code is like: [bash] #!/bin/bash folder="/h …

Adding RedHat DVD as Repository

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 …

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 …