MySQL LENGTH Function with Examples

How to Use the MySQL LENGTH Function In this tutorial, you’ll learn how to use the MySQL LENGTH() function. LENGTH() is a function to return the length of a given string. LENGTH Syntax The syntax of the LENGTH() function is as follows: LENGTH(string) Examples Example 1 The following statement returns the length of the string: … Read more

MySQL FIND_IN_SET() Function with Examples

How to Use the MySQL FIND_IN_SET() Function In this tutorial, you’ll learn how to use the MySQL FIND_IN_SET() function. FIND_IN_SET returns the position of a string within a list of strings. MySQL FIND_IN_SET() Syntax The syntax of the FIND_IN_SET function is as follows: FIND_IN_SET(string, string_list) Arguments String: Required. The string to search for. String_list: Required. … Read more

Python abs() – Absolute Value in Python

How to find the absolute value of a number with the Python abs() function In this tutorial, you will learn how to find the absolute value of a given number using the Python abs() function, which takes one argument and returns the absolute value. Square root in Python Python abs() Function Syntax The syntax of … Read more

Python Factorial – Find the Factorial of a Number

How to Find the Factorial of a Number using factorial() in Python In this tutorial, you’ll learn how to find the factorial of a number using the factorial function in Python. In addition to factorial(), this tutorial also gives you sample programs to find the factorial of a number using recursion, the while loop and for loop statements without recursion. Python factorial() … Read more

MySQL UPDATE Statement with Examples

MySQL-Update-Statement-and-Examples

How to Use an Update Statement in MySQL In this tutorial, you will learn how to use the MySQL UPDATE statement and write SQL queries to update tables in MySQL. To update a table, write the MySQL UPDATE statement as follows: UPDATE table SET column1=value1,column2=value2,…columnN=valueN WHERE where_condition No comma between the last column and a … Read more

MySQL SUBSTRING Function with Examples

How to Use the MySQL SUBSTRING Function In this tutorial, you’ll learn how to use the MySQL SUBSTRING function.  SUBSTRING is a function to extract a substring from a given string. MySQL SUBSTRING() Syntax The syntax of the SUBSTRING function is as follows: SUBSTRING(string FROM position FOR length); or: SUBSTRING(string, position, length); Arguments string: Required. It is the … Read more

Excel SUMPRODUCT Function and Formula with Examples

How to Use the SUMPRODUCT Function and Formula in Excel In this tutorial, you’ll learn how to use the SUMPRODUCT function and formula in Excel.  SUMPRODUCT multiplies arrays or ranges and returns the sum of products. SUMPRODUCT Syntax The syntax of the SUMPRODUCT() function is as follows: =SUMPRODUCT(array1, [array2], [array3],…) For example: =SUMPRODUCT({1,2,3}, {10,20,30}) =SUMPRODUCT(A1:B4, D2:E4) Return value … Read more

Python List sort() Method with Examples

How to Sort a List in Python In this tutorial, you’ll learn how to sort a list using the list sort() method in Python. Also, this tutorial illustrates sample programs on how to use the range() function and the FOR loop statement to sort a list of numbers, strings, and lists without using the list sort() method. List sort() Method Syntax … Read more

Python input() Function with Examples

How to Use the input() Function in Python In this tutorial, you’ll learn how to use the input() function in Python. This tutorial also gives you sample programs to illustrates examples of using the input() function with the IF and WHILE loop statements. Python input() Function Syntax input(string) Argument string: The input string representing a … Read more