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 is mysql aggregate functions? Explain
How do I stop a mysql command?
What is sharding in mysql?
What is pdo in mysql?
What is a longblob?
SQL is not case sensitive. DELETE is the same as delete. State Whether True or False?
How to returns the columns and column information pertaining to the designated table.
What is trigger in mysql?
How to Join tables on common columns.
What is meant by decimal (5,2)?
How can we change the name of a column of a table?
What are the different column comparison operators in mysql?
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)