How do stored procedures work?
Answer / Jyoti Chandra Srivastava
Stored Procedures in MySQL are precompiled programs made up of SQL statements, functions and triggers that are saved for reuse. They can be called from client applications and other programs as needed. Here is an example of creating a stored procedure:n`nCREATE PROCEDURE myProcedure()nBEGINnSELECT * FROM myTable;nEND;n`
| Is This Answer Correct ? | 0 Yes | 0 No |
How do you start and stop MySQL on Windows?
How can we change the name of a column of a table?
Difference between CHAR and VARCHAR?
If we create a column with data type VARCHAR(3), what would we expect to see in MySQL table?
What is the use of count function in mysql?
What is the difference between the primary and unique key in mysql?
What is the difference between truncate and delete in mysql?
How do you connect MySQL database with PHP?
What is the difference between truncate and delete?
What are the difference between mongodb and mysql?
How to make a column bigger and delete unique from table.
Can we create table in stored procedure?
Oracle (3253)
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)