Interested to Buy Any Domain ? << Click Here >> for more details...
What different Stored Objects are supported in MySQL?
- 1 Answers
- 1583 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
How to Creating a new user. Login as root. Switch to the MySQL db. Make the user. Update privs.
Why do we use preparedstatement?
What is mysql optimization?
What is difference between microsoft sql and mysql?
Is blocked because of many connection errors unblock with mysqladmin flush hosts?
What is the command used to create a database using php and mysql?
What storage engines are used in MySQL?
How to drop an existing table in mysql?
What are the advantages of mysql in comparison to oracle?
What is datatype in mysql?
What do you need to connect php to mysql?
What is new mysqli?
What is mysql root?
What is row level locking in access?
Restore database (or database table) from backup.
