MySQL INSTR Function with Examples

How to Use the MySQL INSTR Function In this tutorial, we’ll learn how to use the MySQL INSTR() function. INSTR() returns the position of the first occurrence of substring in a given string. MySQL INSTR Syntax The following is the syntax of the INSTR() function: INSTR(string, substring) Remark INSTR() returns 0 if substring or string … Read more

MySQL DELETE Statement with Examples

How to Use DELETE Statement in MySQL In this tutorial, you’ll learn how to use the MySQL DELETE statement to delete records from a table in a database. To delete one or more records from a table in MySQL database, you write the MySQL DELETE statement as follows: DELETE FROM table WHERE conditions; In the above statement, you need … Read more

Excel MAX Function and Formula with Examples

How to Use the MAX Function and Formula in Excel In this tutorial, you’ll learn how to use the Excel MAX function.  MAX() is a function to get the largest number in a set of numbers. MAX Syntax The syntax of the MAX() function is as follows: =MAX(value1, [value2], …) Arguments value1: The first argument value2: Optional. … Read more

Python List Methods and Functions with Examples

List Methods and Functions in Python Python has some list methods and built-in functions that you can use on lists. 1. List Methods The following is a list of Python list methods: Method Description append(item) Adds an element to the end of the list ——————————– Example:list = [‘Apple’, ‘Grape’, ‘Melon’]list.append(‘Mango’) extend(iterable) Adds all elements of … 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 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

How to Use an Update Statement in MySQL In this tutorial, you’ll learn how to write a query or statement to update a table in MySQL. To update data that already stored in a table in MySQL, you can use UPDATE and SET. To update a table, you can write the MySQL UPDATE statement as follows: UPDATE table SET column1=value1,column2=value2,…columnN=valueN … Read more

Excel SUBTOTAL Function and Formula with Examples

How to Use the SUBTOTAL Function and Formula in Excel In this tutorial, you’ll learn how to use the SUBTOTAL function and formula in Excel.  SUBTOTAL() is a function to return a subtotal in a list or database. SUBTOTAL Syntax The syntax of the SUBTOTAL() function is as follows: =SUBTOTAL(function_num,ref1,[ref2],…) Return value A subtotal in a list or … Read more