MySQL CASE Function In this tutorial, we will learn about MySQL CASE Function. The CASE function provides a branching evaluation construct. CASE Function When the initial expression value is present, CASE compares it to the expression following each WHEN. For the first one that is equal, result for the corresponding THEN value is returned. This […]
In this tutorial, we will learn about MySQL Flow Control functions. The flow control function enables us to choose between different values based on the result of an expression. Some of the
In this tutorial, we will learn about MySQL RIGHT function with an example. The function returns the rightmost length of characters from the string.
MySQL LEFT Function In this tutorial, we will learn about MySQL LEFT function with an example. The function returns the leftmost length of characters from the string. Syntax The general syntax of the function is as follows: LEFT(string,length) Example mysql> SELECT LEFT(‘TestingDocs’,4); +———————–+ | LEFT(‘TestingDocs’,4) | +———————–+ | Test | +———————–+ 1 row in set […]
In this tutorial, we will learn about MySQL STRCMP function with an example. STRCMP() function is a string comparison function. We can use this function to compare strings.
Java Abstract Class with Examples In this tutorial, you will about the Java Abstract class concept. An abstract class in Java is a class that cannot be instantiated on its own and is meant to be inherited by other classes. It can contain abstract methods (without body) and non-abstract methods (with body). Any class that contains one […]
