What different Stored Objects are supported in MySQL?
Answer Posted / hrindows@gmail.com
Different stored objects in MySQL include VIEW, STORED PROCEDURE, STORED FUNCTION, TRIGGER, EVENT.
• VIEW - It is a virtual table based on a result set of a database query.
• STORED PROCEDURE - It is a procedure stored in database which can be called using CALL statement. Stored procedure does not return a value.
• STORED FUNCTION - It is like function calls which can contain logic. It returns a single value and can be called from another statement.
• TRIGGER - Trigger is program which is associated with a database table which can be invoked before or after insert, delete or update operations.
• EVENT - Event is used to run a program or set of commands at defined schedule.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is difference between oracle sql and mysql?
What is mysql uuid?
How to use case expression?
How many types of indexes are there in mysql?
What is the difference between timestamp and datetime in mysql?
How many columns can be used for creating Index?
How to convert character strings to dates?
Is the syntax correct? Explain the meaning of the syntax given below: $dbc = mysqli_connect('data.aliensabductedme.com', 'owen', 'aliensrool', 'aliendatabase');
How to give user privilages for a db. Login as root. Switch to the mysql db. Grant privs. Update privs.
Can we write pl sql mysql?
How do you flush privileges?
What are the mysql database files stored in system ?
What is the default port number of mysql?
What is a scalar function?
How do I find my mysql username and password?