What different Stored Objects are supported in MySQL?
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 |
What is sharding in mysql?
What is mysqli_select_db?
What is field in mysql?
How do I show all mysql databases?
Why we use mysql workbench?
What are date and time data types in mysql?
Is mysql open source?
How can we find out which auto increment was assigned on Last insert?
What can I do with mysql?
What is a crosstab query?
What is the difference between MyISAM Static and MyISAM Dynamic?
can you tell what are the different set operations available in mysql? : Mysql dba