Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


What different Stored Objects are supported in MySQL?



What different Stored Objects are supported in MySQL?..

Answer / 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

More MySQL Interview Questions

How can you retrieve a particular number of records from a table?

0 Answers  


Restore database (or database table) from backup.

0 Answers  


can you tell the order of sql select statement? : Mysql dba

0 Answers  


How can you change the password of a mysql user?

0 Answers  


How to enter numeric values as hex numbers?

0 Answers  






Where is mysql password stored?

0 Answers  


How do I start mysql?

0 Answers  


How do I view tables in mysql workbench?

0 Answers  


How to use regular expression in pattern match conditions?

0 Answers  


how we can find nth max salary from an employe table by using my sql?

8 Answers  


How to insert html code into mysql database using php?

0 Answers  


How to run a sql statement?

0 Answers  






Categories