Interested to Buy Any Domain ? << Click Here >> for more details...
What different Stored Objects are supported in MySQL?
- 1 Answers
- 1685 Views
- I also Faced
- E-Mail Answers
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 a definer?
What does it mean to be case sensitive?
What is difference between mysql and mysql workbench?
How to returns the columns and column information pertaining to the designated table.
Can you tell few best practices to be followed for optimization in sql?
What is data type for image in mysql?
What is cast in mysql?
What is difference between statement and preparedstatement?
What is dump in mysql?
What is relational database in mysql?
how to Return total number of rows.
What is the data source name for mysql?
How to convert dates to character strings?
What is 'mysqlshow'?
Explain the different types of constraints?
