Interested to Buy Any Domain ? << Click Here >> for more details...
What different Stored Objects are supported in MySQL?
- 1 Answers
- 1488 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 the data source name for mysql?
What is procedures in mysql?
Which is faster innodb or myisam?
How to return query output in html format?
What is database migration in mysql?
Why use stored procedures in mysql?
What is current version of mysql?
What is myisam?
Can you tell a way to know the number of days between the two given dates in php?
how to dump all databases for backup. Backup file is sql commands to recreate all db's.
What are the 3 main types of search queries?
How do I install mysql?
What is a mysql model?
How to install mysql?
What is mysql connector used for?
