The LEFT JOIN combines two tables and returns the matched records from both tables and unmatched records from the “left” table as well. As such, one table Continue Reading
MySQL Tutorials
The DISTINCT clause in MySQL is used to fetch the unique records from the table. The DISTINCT is used with the SELECT statement and removes the duplicate Continue Reading
The LIKE operator is used to fetch records from the table data with the pattern. The LIKE operator is generally used with wildcards; % and _ i.e. Continue Reading
MySQL has two types of IFs: one is the IF statement while the other is the IF function. In this tutorial, I will explain the difference and Continue Reading
If you have a little idea about how if..else..elseif statement works in different programming languages then understanding the MySQL CASE function should be straight-forward. The CASE..WHEN…THEN..END combination Continue Reading
The COUNT function in MySQL returns the total count of rows returned by the SELECT statement. You may use it with the simple SELECT statement to get Continue Reading
is used to retrieve records based on the given range The MySQL BETWEEN operator can be used with SELECT, DELETE, UPDATE and INSERT statements. The two values Continue Reading
The ORDER BY clause is used to sort the record-set in ascending or descending order. A few points about the MySQL ORDER BY clause: The default sorting Continue Reading
The group by clause: Used in the select statement It is used to group the rows with the same values Optionally and generally, the GROUP BY is Continue Reading