Answer Posted / hrindows@gmail.com

The MySQL aggregate function performs a calculation on a set of values, and it returns a single value as output. It ignores NULL values when it performs calculation except for the COUNT function.
MYSQL Aggregrate functions are listed below:
 AVG()
 COUNT()
 SUM()
 MIN()
 MAX()

Why mysql is so popular?

688

---

In how many ways we can retrieve the data in the result set of MySQL using PHP? What is the difference between mysql_fetch_object and mysql_fetch_array ?

735

---

What is difference between oracle and mysql?

670

---

What is meant by sharding?

665

---

How do I view mysql logs?

677

---

What are triggers mysql?

649

---

What is mysqli_connect_error ()?

720

---

What is mysql and why it is used?

757

---

Can you tell the difference between ereg_replace() and eregi_replace()?

736

---

What is the purpose of using timestamp data type?

669

---

Why do we use views instead of tables?

646

---

How do I free up space in mysql?

661

---

What are the advantages of myisam over innodb?

732

---

how to show all records starting with the letters 'sonia' and the phone number '9876543210' limit to records 1 through 5.

683

---

How triggers can be used in mysql?

733

---