Interested to Buy Any Domain ? << Click Here >> for more details...
What different Stored Objects are supported in MySQL?
- 1 Answers
- 1590 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 many rows can be inserted in mysql at a time?
How can we get the number of rows affected by query?
How to display nth highest salary from a table in a mysql query?
How many entries can mysql handle?
How to convert numeric values to character strings?
How to present a past time in hours, minutes and seconds?
Write a command with which mysql table can be repaired
How many triggers are possible in mysql?
Can varchar be primary key?
What are the functions used to encrypt and decrypt the data present in mysql?
HOW TO FIND display the total number of weeks in the year of 1998 IN EMP TABLE
How are mysql timestamps seen to a user?
Can't connect mysql server on localhost?
In how many ways we can retrieve data in the result set of mysql using php?
What is the difference between procedure and function in mysql?
