What is MySQL Stored Procedure?
- 1 Answers
- 1049 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 we can get the current date in mysql?
What is the use of mysqli_query?
Explain the difference between BOOL, TINYINT and BIT?
Write a command to list all databases in mysql?
What is the password of mysql?
What is field in mysql?
What are the functions of mysql?
How to analyze tables with 'mysqlcheck'?
How do I restore a mysql database dump file in linux?
What are the steps involved in query processing?
What is “i_am_a_dump” flag in mysql?
Write a query to count the number of rows of a table 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 (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
