MYSQL requires reading Notes, Chapter 10 and Chapter 11 using functions to process data _ MySQL

This article mainly introduces the information about using functions to process data in chapters 10 and 11 of MYSQL's required reading notes. For more information, see the following code:

Select avg (prod_price) as avg_pricefrom products;

-Count

Use count (*) to count the number of rows in the table (whether null or not)

Use count (column) to count rows with values for a specific column, ignore null

Sum

Use sum () to return the sum of the specified column values

The above is a small Editor to introduce you to MYSQL, you must know the Reading Notes, Chapter 10 and Chapter 11 about using functions to process data, I hope to help you!