In Kotlin, the while works just like in Java. So, if your background is Java then you already know how it works. For beginners, the while loops execute a block of code until the given condition is True.
Demos and Full Guide
The array class represents an array in Kotlin. Array class has get and set functions. The items in array are called elements.
Demos and Full Guide
Kotlin if is an expression that returns a value. This is different if compared with the other languages where if acts as a statement. As, it acts as an expression in Kotlin, so there is no ternary operators (condition ? then : else).
Demos and Full Guide
In Kotlin, we have no switch statement. Instead, Kotlin replaces the switch with the When expression.
Demos and Full Guide
In Kotlin, the ranges has the operator form .. (double dot). A Kotlin range can also be created by using the rangeTo() and downTo() function.
Demos and Full Guide
The for loop in Kotlin can be used to iterate through anything that provides an iterator. For example, a range, array, string, etc.
Demos and Full Guide
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
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
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
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
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
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
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
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
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