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 the password of mysql?
Fname Lname City Pin ramesh kumar salem 365241 Query to generate a code having the firstletter of Fname,Lname & 3letter of city Last 3letter of pin,all in capital letters
How to validate email addresses in mysql?
How do I install and use mysql?
What is a session in mysql?
What is a trigger in mysql?
Query to select passwords from a table having a column "Password" Whose length is b/w 8 &15 and having 'A' as the first character in the password irrespective of case.
How do you create a schema?
What do you mean by % and _ in the LIKE statement?
How do I zip a file in mysql?
Is sql similar to mysql?
How to Creating a new user. Login as root. Switch to the MySQL db. Make the user. Update privs.
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)