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 sql does mysql use?
What is 'mysqladmin' in mysql?
What is longblob in mysql?
List data types in mysql? Explain
What is the difference between the primary and unique key in mysql?
How to calculate the difference between two dates?
What is information_schema in mysql?
What is the purpose of using a heap table?
What is truncate command?
How can I see all mysql databases?
How do I setup a mysql database?
What is mysql connector used for?
What are the advantages of MySQL when compared with Oracle?
Where is the mysql data directory?
What are the differences between char and varchar?