Web Application for Online Restaurant Management

Dear Students, you may refer the attached Netbeans project to be used and modified as per your project requirements.

Click here to download Netbeans project

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

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