What is MySQL Stored Procedure?
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 functions in mysql?
Does mysql use sql?
can you elaborate on blob and text in mysql? : Mysql dba
How can we find the number of rows in a table using MySQL?
How to shutdown mysql server?
How do I install mysql?
How big is a blob mysql?
Write a query to find duplicate rows in table?
How do I grant privileges to a user in mysql phpmyadmin?
What are the disadvantages of mysql?
What are the drivers in MySQL?
A select query over a large table runs very slow because of the growing number of entries in that table. What different measures could be taken to improve speed?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)