Online Tutorials | C#, Python, MySQL, Excel
How to Use the MySQL DATE_ADD() Function This tutorial explains how to use MySQL DATE_ADD() function, which adds a time or date interval to a given date and returns a new date. To subtract a time or date interval from a given time, use the DATE_SUB() function. MySQL DATE_ADD() Syntax The syntax of the DATE_ADD() … Read more
How to Use the MySQL DATE_SUB() Function In this tutorial, you’ll learn how to use the MySQL DATE_SUB() function. The DATE_SUB() function subtracts a time and date interval from a given date and returns a new date. To add the date and time to a given date, use the DATE_ADD() function. MySQL DATE_SUB() Syntax The syntax of the DATE_SUB() … Read more
How to Use the MySQL NULLIFF() Function In this tutorial, you will learn how to use the MySQL NULLIF() function, which compares two expressions and returns NULL if equal; otherwise returns the first expression. MySQL NULLIF() Syntax The syntax of the NULLIF() function is as follow: NULLIF (expression_1, expression_2) NULLIF Examples Example 1 The following … Read more
How to User the YEAR() Function in MySQL In this tutorial, you will learn how to use the MySQL YEAR() function to extract the year portion of a given date. Syntax of the MySQL YEAR() Function The syntax of the YEAR() function is as follows: YEAR(date) YEAR() Function Examples Example 1: Extract the year portion … Read more
How to Use the MySQL LOCATE Function This tutorial explains how to use the MySQL LOCATE function, which returns the position where the substring first appears in a given string. See also: MySQL COUNT() function MySQL SUM() function MySQL SUBSTRING() function MySQL LOCATE() Syntax The syntax of the LOCATE function is as follows: LOCATE(substring, string) … Read more
How to Use the MySQL IFNULL() Function In this tutorial, you will learn how to use the MySQL IFNULL() function that returns the specified value if the expression is NULL; otherwise returns that expression. If you want to compare two expressions and return NULL if they are equal, use the NULLIF() function. IFNULL() Syntax The … Read more
How to Use the MySQL CROSS JOIN In this tutorial, we’ll learn how to use the CROSS JOIN in MySQL. CROSS JOIN returns the Cartesian product of 2 tables, returning all possible combination of all records. For example, suppose we join the employees table, containing 4 records, and departments table, containing 3 records. Since CROSS … Read more
How to Use the MySQL LOOP Statement In this tutorial, you will learn how to use a LOOP statement in MySQL. A LOOP statement is a simple loop construct that allows you to repeatedly execute a block of SQL code consisting of one or more SQL statements ending with a semicolon (;). There are two … Read more
How to Use the MySQL DROP COLUMN Statement In this tutorial, you will learn how to drop a column from a table in MySQL. There are many reasons why you may need to drop a column from a table. For example, you may need to create a new column instead of changing an existing one, … Read more
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