Wednesday, September 2, 2009

MYSQL Procedures

Hi,
Here is the sample of the creating the procedures & excuting the procedures.
Creating Procedure:
CREATE PROCEDURE appl_osmp.createTest(IN testName VARCHAR(20), IN ComponentIDs TEXT )
BEGIN
DECLARE TagID INT DEFAULT 1;
INSERT INTO TEST (name) VALUES (testName);
END

Droping procedure :
drop procedure createTest;

Call the procedure:
call createTest("tom5","16395,16722,17175,16999");

No comments: