Showing posts with label MySql. Show all posts
Showing posts with label MySql. Show all posts

Wednesday, 25 March 2020

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

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