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 |
Have you ever used MySQL Administrator and MySQL Query Browser? Describe the tasks you accomplished with these tools?
How do I free up space in mysql?
How can I create a database in mysql?
What is mysql in linux?
How do I flush privileges in mysql?
how to dump all databases for backup. Backup file is sql commands to recreate all db's.
Why does mysql have so many connections?
What is the difference between char and varchar?
What is datadir?
What is procedures in mysql?
What is the difference between the primary and unique key in mysql?
What is dirty read and phantom read?
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)