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()

What is the use of mysqli_query?

879

---

What is the default port for mysql and how it can change?

1048

---

What are enums used for in mysql?

999

---

Explain about reporting services of MYSQL?

1060

---

How to represent ENUMs and SETs internally?

1127

---

What are the types of index?

942

---

How database are managed?

986

---

Can mysql and mariadb coexist?

1084

---

What is the maximum size of table in mysql?

1023

---

Which mysql function is used to concatenate string?

1479

---

How to display odd rows in student table in mysql?

993

---

Is sqlite faster than mysql?

934

---

What is 'mysqlcheck'?

1016

---

Write a command to view mysql database table structure?

962

---

What is the phantom problem?

995

---