Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


What is MySQL Stored Procedure?



What is MySQL Stored Procedure?..

Answer / hrindows@gmail.com

A procedure (often called a stored procedure) is a collection of pre-compiled SQL statements stored inside the database. It is a subroutine or a subprogram in the regular computing language.
A procedure always contains a name, parameter lists, and SQL statements.
We can invoke the procedures by using triggers, other procedures and applications such as Java,Python,PHP etc. It was first introduced in MySQL version 5. Now almost, it can be supported by almost all relational database systems.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MySQL Interview Questions

What are the types of index?

0 Answers  


at first i'm using datediff('d', a.due_date, current_date); but it takes too long to get the result but how can i subtract the current_date - a.due_date and still get the same result like when i use datediff? thank you

1 Answers  


How do I run mysql on a mac?

0 Answers  


How to use like conditions?

0 Answers  


What is mysql uuid?

0 Answers  






Fname Lname City Pin ramesh kumar salem 365241 Query to generate a code having the firstletter of Fname,Lname & 3letter of city Last 3letter of pin,all in capital letters

3 Answers  


How can you count the total number of records of any table?

0 Answers  


Explain csv tables.

0 Answers  


What is mysql primary key?

0 Answers  


How to drop an existing view in mysql?

0 Answers  


How do we use % when performing a search query?

0 Answers  


What is delimiter in mysql?

0 Answers  






Categories