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.

How do I view a mysql database?

0 Answers  

---

What is the difference between float and double?

0 Answers  

---

What is mysqli_num?

0 Answers  

---

How do I run mysql without installing?

0 Answers  

---

What are views in mysql?

0 Answers  

---

I have a table like this tblData (month int,Qty int) and i am inserting three rows in this table 1.tblData Values (1,100) 2.tblData Values (2,200) 3.tblData Values (3,300) The Result I want is the Running total of the field Qty that is 1 100 100 2 200 300 3 300 600 What is the Query for that ?

4 Answers  

---

Can mysql handle billions of records?

0 Answers  

---

What is the difference between mysql and oracle?

0 Answers  

---

What is the difference between mysql_fetch_array and mysql_fetch_object?

4 Answers   CTS,

---

maximum database size of mysql database

2 Answers  

---

What is the default port for MySQL Server?

0 Answers  

---

Explain GRANT command in MySQL.

1 Answers  

---