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 |
Who developed mysql?
How do I copy a table in mysql?
How to write optimized query in mysql?
Is mysql open source?
Why do we use preparedstatement?
Consider you have the following three tables which have to be linked together.
i made a table whih contain a column "Photo" with image data type and i want to insert the byte of a picture present in my hardisk using insert statement in that colum... so what will be my insert statement?
What is max connections in mysql?
Is mysql still relevant?
How MySQL is different from SQL?
17 Answers HCL, IBM,
What is the datatype of image in mysql?
Is mysql a scripting language?
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)