MySQL Functions

MySQL Functions

MySQL has many built-in functions.

String Functions

ASCII, CONCAT, LENGTH, UPPER, LOWER, TRIM, SUBSTRING...

Numeric Functions

ABS, AVG, CEIL, FLOOR, COUNT, MAX, MIN, SUM, ROUND...

Date Functions

CURDATE, DATE, DATEDIFF, DATE_ADD, DATE_FORMAT, NOW...

SELECT UPPER(CustomerName) FROM Customers;