Online Tutorials | C#, Python, MySQL, Excel
How to Add Columns to a Table in MySQL In this tutorial, you will learn how to add columns to a MySQL table using the MySQL ADD COLUMN statement, which allows you to add single or multiple columns in a single MySQL statement. If you want to delete the existing columns, use the DELETE COLUMN … Read more
How to Use the MySQL AVG() Function In this tutorial, we’ll learn how to use the AVG() function to calculate the average value of an expression in MySQL. MySQL AVG() Syntax The syntax of the AVG() function is as follows: AGV([DISTINCT] expression) Remarks The expression argument is required, and can be a column name or … Read more
How to create a user account using the CREATE USER statement in MySQL with examples This tutorial explains how to create a user account in MySQL using the CREATE USER statement. It is possible to create a user account that can connect to the MySQL database server from localhost, a specified host, or any host. … Read more
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
How to Rename a Table in MySQL In this tutorial, you will learn how to rename a table using the MySQL RENAME TABLE statement. See also: MySQL ALTER TABLE statement RENAME TABLE Syntax To rename a table in MySQL, use the following statement: RENAME TABLE old_table_name TO new_table_name; You can also rename multiple tables at … Read more
How to Get the Current Date in MySQL using CURDATE() In this tutorial, you’ll learn how to use the MySQL CURDATE() function. CURDATE() is a function to return the current date. MySQL CURDATE() Syntax The syntax of the CURDATE() function is as follows: CURDATE() Remark This function is equal to the CURRENT_DATE() function MySQL returns … Read more
How to Use the DELETE Statement in MySQL In this tutorial, you will learn how to use the MySQL DELETE statement to delete rows from a table in a database. These are four basic SQL statements: SELECT (retrieve rows), INSERT (adding rows), UPDATE (update the existing rows), and DELETE (delete rows). This tutorial explains how … Read more
How to remove user accounts in MySQL with Examples This tutorial explains how to use the DROP USER statement to delete user accounts and their privileges in MySQL. Learn more: How to create users in MySQL DROP USER Syntax The syntax of the DROP USER statement is as follows: DROP USER user [, user] … … Read more
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
How to use the Python return Statement In this tutorial, you’ll learn how to use the Python return statement with examples. What is the return statement in Python? A return statement is a statement that occurs in a function definition used to return a value to a function call. The return Statement Syntax The following … Read more
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
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
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
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
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
How to delete a table using the MySQL DROP TABLE statement This tutorial explains how to drop a table in MySQL using the DROP TABLE statement, which allows you to drop one or more tables in MySQL with a single SQL query. Learn more: Create a table in MySQL Rename a table in MySQL MySQL … Read more
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
How to Use the min() Function in Python In this tutorial, you will learn how to find the smallest value in Python using the min() function. This tutorial also provides an example of finding the smallest value in a list without using the built-in functions min() and sort(). Python max() function Python min() Function Syntax … Read more
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
How to Use the max() Function in Python This tutorial explains how to use the Python max() function to find the maximum value. This tutorial will also show you an example of how to find the max value in a list without using the built-in max() function. Learn more: Python min() function Python max() Function … Read more