MYSQL FUNCTIONS(MATHS, STRING, DATE AND TIME AND GROUP FUNCTIONS)

suman 08:08:00

 



1. Case-manipulation Functions These functions convert case for character strings:
Class 12 Informatics Practices Notes Chapter 11 SQL Functions and Table Joins 1.1

2. Mathematical functions are also called number functions that accept numeric input and return numeric values.
Class 12 Informatics Practices Notes Chapter 11 SQL Functions and Table Joins 3


3.   Date and Time Functions
Date functions operate on values of the DATE data type:
Class 12 Informatics Practices Notes Chapter 11 SQL Functions and Table Joins 4

4.     GROUP (Aggregate) Functions
There are following aggregate or group functions available in MySQL:
Class 12 Informatics Practices Notes Chapter 11 SQL Functions and Table Joins 5

Post a Comment

0 Comments

Please do note create link post in comment section