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
How to print formatted string in Python?
The ‘%’ or modulus operator is generally supported in many languages and so in Python. In this tutorial, we will look at ‘%’ operator and string.format() function for string formatting in Python.
Demos and Full Guide
Calculate exponent in Python
In Python, you may use different ways for calculating the exponents. All these are explained in this tutorial with example code.
Demos and Full Guide
What is Python floor function?
The floor function is the part of math module that returns the floor of given number (x) which is largest integer number less than or equal to the x. For example:
Demos and Full Guide
Python Modulo operator
In Python and generally speaking, the modulo (or modulus) is referred to the remainder from the division of the first argument to the second.
Demos and Full Guide