adspace


How do stored procedures work?

Answer Posted / Jyoti Chandra Srivastava

Stored Procedures in MySQL are precompiled programs made up of SQL statements, functions and triggers that are saved for reuse. They can be called from client applications and other programs as needed. Here is an example of creating a stored procedure:n`nCREATE PROCEDURE myProcedure()nBEGINnSELECT * FROM myTable;nEND;n`

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which statement is used in a select query for partial matching?

1247


What is the current mysql version?

1103


How to Change a users password from unix shell.

1221


What is current version of mysql?

1081