How do stored procedures work?



How do stored procedures work?..

Answer / 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

More MySQL Interview Questions

How do you start and stop MySQL on Windows?

3 Answers  


How can we change the name of a column of a table?

7 Answers  


Difference between CHAR and VARCHAR?

1 Answers  


If we create a column with data type VARCHAR(3), what would we expect to see in MySQL table?

2 Answers   ABC,


What is the use of count function in mysql?

1 Answers  


What is the difference between the primary and unique key in mysql?

1 Answers  


What is the difference between truncate and delete in mysql?

1 Answers  


How do you connect MySQL database with PHP?

1 Answers  


What is the difference between truncate and delete?

1 Answers   DELL,


What are the difference between mongodb and mysql?

2 Answers  


How to make a column bigger and delete unique from table.

1 Answers  


Can we create table in stored procedure?

1 Answers  


Categories