Stored Procedures Mysql Tutorial Pdf
Mysql Stored Procedure Programming
.A stored procedure that returns no result. For example, such astored procedure can log non-critical information, or changedatabase data in a straightforward way.The following procedure adds a country to theworld database, but does not return aresult:CREATE PROCEDURE addcountry (IN countrycode CHAR(3),IN countryname CHAR(52),IN continentname CHAR(30))BEGININSERT INTO Country(Code, Name, Continent)VALUES (countrycode, countryname, continentname);END;.A stored procedure that returns one or more values usingoutput parameters.