What different Stored Objects are supported in MySQL?
- 1 Answers
- 1020 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 give user privilages for a db. Login as root. Switch to the mysql db. Grant privs. Update privs.
Write a program using the select statement, while loop.
What is the maximum connection pool size?
How many primary keys can be there in a table?
What is the limit of mysql database?
Can we rollback truncate in mysql?
When to use order by in delete statement?
What is data node in mysql cluster?
How to create a new table by selecting rows from another table in mysql?
How do I run mysql?
How to convert numeric values to character strings?
What is the purpose of using ifnull() function?
How do I clear a mysql database?
How can we change the data type of a column of a table?
Is mysql free download?
