Interested to Buy Any Domain ? << Click Here >> for more details...
What different Stored Objects are supported in MySQL?
- 1 Answers
- 1474 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 mysqli_select_db?
What is the storage engine for mysql?
What is the use of mysqli_fetch_assoc?
Why do gaps in sequences occur?
What is row locking in mysql?
How to get a version of mysql?
how to display nth highest salary from a table in a mysql query? : Mysql dba
How to get data from mysql in php?
How would you enter characters as hex numbers?
How can we optimize stored procedure?
How many types of indexes are there in mysql?
What tools available for managing mysql server?
Is mongodb faster than mysql?
What is ndb in mysql?
How do you concatenate strings in mysql?
