Wednesday, 24 June 2015

MySql stored procedure and stored function

Dear Viewers,

This post demonstrates MySql stored procedure and stored function. Small dataset considered is as below

mysql> select * from student;
| rno  | name    | class | division |
|    1 | John    | TE    | A        |
|    2 | Peter   | TE    | A        |
|    1 | David   | TE    | B        |
|    2 | Solomon | TE    | B        |

Monday, 22 June 2015

Shell script to perform simple file operations

Dear Viewers
Below shell script handles basic file operations. Linux commands used to perform operations are:
1. echo - to print on standard output
2. read - to read user input
3. touch - to create a file
4. mv - to rename a file
5. rm - to remove a file
6. ls - to list the contents of current directory  

Thursday, 18 June 2015

Basic MySql commands for beginner

Dear Viewers,

This post is presenting basic MySql commands useful for MySql beginner. For demonstration purpose I have used MySql installed on Ubuntu 12.04.

1. Check mysql service status
pavan@ubuntu:~$ service mysql status
mysql start/running, process 1583

2. Stop mysql service
pavan@ubuntu:~$ sudo service mysql stop
mysql stop/waiting

Tuesday, 9 June 2015

"Backspacce" key not working in Fedora nautilus

Dear Viewers,

While using Fedora distributions, you might have experienced that "Backspace" key on nautilus do not work. In simple words, nautilus means filesystem hierarchy under "/". So every time to visit or to go back to previously accessed folder, you have to make use of mouse and click on "Back" button available on left top corner. So if you wants to get rid out of this and wish to use shortcut key, then follow the process given below:

1. Open terminal
2. Type in  vi /root/.config/nautilus/accels 
3. Replace the user root by the user name for whom you would like to apply these settings. Important is you have to provide absolute path.
4. Go into "Insert" mode on VI, and copy paste below line as it is
 (gtk_accel_path "<Actions>/ShellActions/Up" "BackSpace") 
5.Press "Esc" then ":" and type "wq"
6. This will save the changes made and will take you back on terminal
7. On terminal type either "nautilus -q" or "killall nautilus"
8. Now open any folder, jump to any directories and cross check whether "Backspace" started working. 
9. You are done.

All The Best.....