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 mysql workbench a dbms?

1 Answers  

---

What is blob and clob?

1 Answers  

---

What is the purpose of using ifnull() function?

1 Answers  

---

What does TIMESTAMP ON UPDATE CURRENT_TIMESTAMP data type do?

1 Answers  

---

How do I know if mysql is installed on windows?

1 Answers  

---

What are some good ideas regarding user security in MySQL?

2 Answers  

---

Write a query to stop mysql in unix

1 Answers  

---

How to do login in mysql with unix shell.

1 Answers  

---

Is mysql relational database?

1 Answers  

---

How to create table with same structure of student table in mysql?

1 Answers  

---

What is view in mysql?

1 Answers  

---

What is the maximum connection pool size?

1 Answers  

---