What is MySQL Stored Procedure?
- 1 Answers
- 999 Views
- I also Faced
- E-Mail Answers
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 |
How do you use auto increment?
What does mysql_fetch_assoc do?
What is striped backup
What is ndb in mysql?
Is sql similar to mysql?
What are the indexes in mysql?
Does mysql use sql?
How do stored procedures work?
What are the difference between now and current_date in mysql?
How to represent ENUMs and SETs internally?
How do I create a stored procedure in mysql?
What is definer in mysql?
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
