What is MySQL LEFT JOIN?
The LEFT JOIN combines two tables and returns the matched records from both tables and unmatched records from the “left” table as well.
Demos and Full Guide
What is DISTINCT clause in MySQL?
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 duplicate records from the record-set.
Demos and Full Guide
A few points about the MySQL LIKE operator
The LIKE operator is used to fetch the records from the table data with the pattern. The LIKE operator is generally used with wildcards; % and _ i.e. percentage and underscore.
Demos and Full Guide
The “IFs” in MySQL
MySQL has two types of IFs: one is the IF statement while other is the IF function. In this tutorial, I will explain the difference and show you examples of MySQL IF
Demos and Full Guide
What is MySQL CASE
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.
Demos and Full Guide
What is MySQL COUNT function?
The COUNT function in MySQL returns the total count of rows returned by SELECT statement. You may use it with the simple SELECT statement to get the count of all rows as single number.
Demos and Full Guide
The BETWEEN Operator in MySQL
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 provided in the BETWEEN operator are inclusive. For example, BETWEEN 10 and 20…
Demos and Full Guide
What is MySQL ORDER BY clause?
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:
Demos and Full Guide
What is MySQL GROUP BY clause?
The purpose of the GROUP BY clause is to get summarized view of the database table(s). MySQL GROUP BY is used to group the rows with the same values
Demos and Full Guide
A little about http 503 error code
The “503 Service Unavailable” status code indicates that the server you are trying to access is temporarily down due to overloading or server maintenance issues.
Demos and Full Guide
HTTP 500 Internal Server Error – An Intro
The http 500 error is one of the server response codes that occur for different reasons. In this tutorial, We will explain why 500 internal server error occurs and suggest the solutions for fixing this server error.
Demos and Full Guide
What is Python sin() function?
The sin() function takes an argument (x = number) and returns its sine in radians. It’s the part of math module, so this function cannot be used directly.
Demos and Full Guide
Python all() function
Python all() function takes an argument (which is an iterable) and returns True if all the elements of the iterable are True. If the given iterable is empty, it also returns True.
Demos and Full GuideWhat is Python ascii function?
The ascii function takes an argument (object) that can be a string, list, tuple etc. It Returns a string that contains a printable representation of that object
Demos and Full Guide
What is any() function in Python?
The any() function in Python returns True if any elements of the iterable is True. The any() function takes an argument which is the iterable e.g. a list, dictionary, string, tuple etc.
Demos and Full Guide