1. How to create the stored procedures in mysql and it will be write on where?2. Difference between SQL stored procedures, MYSQL stored procedures, SQL Server stored procedures?

Interview Candidate
Jan 24th, 2007
2
2294

First
Prev
Next
Last

Showing Answers 1 - 2 of 2 Answers

sampra
Profile Answers by sampra

Mar 10th, 2008

will find it soon and then let you know

umapathi.b
Profile Answers by umapathi.b

Jul 24th, 2010

It is just same as creating procedure in Oracle. The only difference is with the syntax.

DROP PROCEDURE IF EXISTS xyz;

eg:
CREATE PROCEDURE xyz ( a int,b char,c varchar)
BEGIN
SELECT now();
SELECT current_date;
END

We can see all the procedure names and the code by using this query.

SELECT * FROM mysql.proc ;