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|
What are the types of index?
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
How do I run mysql on a mac?
How to use like conditions?
What is mysql uuid?
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
How can you count the total number of records of any table?
Explain csv tables.
What is mysql primary key?
How to drop an existing view in mysql?
How do we use % when performing a search query?
What is delimiter in mysql?