MySQL Functions

MySQL Functions Functions are used to perform some specific task. Every functions has a particular pre-defined tasks. functions are categorized into two parts. 1. Single Row Functions These functions operates on a single row at a time. These functions are categorized into following parts- i. Math Functions ii. String Functions iii. Date and Time functions…

Read More

SQL Joins

 JOIN Joins are used to extract data from one or more tables. There are different types of Joins in MySql. Let’s learn about them. 1. CROSS JOIN CROSS JOIN returns the Cartesian product of two tables. Every row of table1 is combined with every row of table2.              Example-  …

Read More