Online Tutorials | C#, Python, MySQL, Excel
StringBuilder in C# with Examples This tutorial describes what StringBuilder is in C# and how to use it. A StringBuilder is a class that presents a mutable string of characters. More C# tutorials: How to write to file in C# How to read text from a file in C# StringBuilder Initialization You can initialize a … Read more
How to Read Text from A File with StreamReader This tutorial describes how to read text from a file with StreamReader in C#. StreamReader provides various methods to read text from a file. Related tutorial: How to write to a file in C# with StreamWriter ReadToEnd Method You can write a program to read text from a … Read more
How to Write Strings and Text to File in C# This tutorial describes how to write strings and text to a file with the File class and StreamWriter in C#. Related tutorial: How to read text from a file with StreamReader 1. Writing text to a file with the File class WriteAllText Method To write text to a … Read more
How to Use switch case Statements in C# This tutorial describes how to use switch case statements in C#. The switch statement chooses one of the blocks of code, which matches the switch expression to execute. We often use the switch-case statements when we test a single expression against three or more conditions. You can use if-else if there are only a few … Read more
How to Use the if-else Statements in C# This tutorial describes how to use the if-else statement in C# programming language. An if statement decides which block of code to execute based on a specified condition. If the specified condition evaluates to true, then code inside the if statement block runs. If the specified condition is false, code inside the else statement block … Read more
How to use a while Loop Statement in C# This tutorial describes how to use a while loop statement in C#. A while loop is a control flow statement to execute a block of code while a specified condition evaluates to true. A while loop can execute zero or more times. If you need to break out the loop, … Read more
In this tutorial, you will learn how to use the MySQL LIKE operator in the WHERE clause of a SELECT statement to retrieve records based on pattern matching. You can use MySQL LIKE to search for any records that meet the specified pattern. MySQL supports two wildcard characters, the percent sign (%) and the underscore sign (_), … Read more
How to Use the for Loop Statement in C# This tutorial describes how to use the C# for loop statement.A for loop is a control flow statement that you allow you to execute a block of code repeatedly. Related C# tutorials: C# foreach loop statement C# while loop statement The for Loop Syntax The syntax … Read more
How to Use the ROUNDUP Function in Excel In this tutorial, you’ll learn how to use the Excel ROUNDUP function. ROUNDUP is a function to round a number up away from 0. ROUNDUP Syntax The syntax of the ROUNDUP() function is as follows: =ROUNDUP(number, num_digits) Return value A rounded number Arguments number: the number that you want … Read more
How to Use the MIN Function in Excel In this tutorial, you’ll learn how to use the Excel MIN function. MIN is a function to get the smallest value in a set of values. MIN Syntax The syntax of the MIN() function is as follows: =MIN(value1, [value2], …) Arguments value1: The first argument value2: [Optional]. The second … Read more
How to Use the COUNTA Function to Count Non-Blank Cells in Excel In this tutorial, you’ll learn how to use the Excel COUNTA function to count non-blank cells. You want to count the number of cells that are not blank, including both numbers and strings. In such a case, you can use the COUNTA function. COUNTA is … Read more
How to Use the COUNTBLANK Function in Excel In this tutorial, you’ll learn how to use the Excel COUNTBLANK function to count blank cells. When you are managing data in Excel, such as the number of people who attended an event or took a test, there may come a time when you want to know how … Read more
How to Use the MySQL SUBSTRING_INDEX() Function In this tutorial, you’ll learn how to use the MySQL SUBSTRING_INDEX() function. SUBSTRING_INDEX() returns a substring of a given string before a specified number of occurrences of delimiter. MySQL SUBSTRING_INDEX() Syntax The syntax of the SUBSTRING_INDEX() function is as follows: SUBSTRING_INDEX(string, delimiter, count) Arguments String: Required. The text from which you … Read more
How to Use The MySQL EXISTS Operator In this tutorial, you will learn how to use the MySQL EXISTS operator. MySQL EXIST operator is often used in subqueries to test whether any record in a subquery exists. If the subquery returns one or more records, the EXISTS operator returns true; otherwise, it returns false. Learn … Read more
How to Use the ROW_NUMBER Function in MySQL In this tutorial, you’ll learn how to use the MySQL ROW_NUMBER function. ROW_NUMBER returns the number of the current record within its partition of a result set. MySQL ROW_NUMBER() Syntax The syntax of the ROW_NUMBER() function is as follows: ROW_NUMBER() OVER( PARTITION BY expression [, expression], … ORDER BY expression [ASC | DESC], [, expression], … Read more
How to concatenate strings using the MySQL CONCAT() function and examples This tutorial explains how to concatenate strings using the MySQL CONCAT() function. You will learn how to use the MySQL CONCAT() function, which is a function that adds two or more expressions together. Learn more: MySQL GROUP_CONCAT() function MySQL CONCAT() Syntax CONCAT(expression1, expression2,…, expressionN) … Read more
How to Use the MySQL IN Operator In this tutorial, you will learn how to use the MySQL IN operator.MySQL IN operator is used to check whether a value is within a set of values. Other tutorials: How to use the LIKE operator in MySQL MySQL IN Syntax The syntax of the IN operator is … Read more
How to Use the SUMIFS Function in Excel In this tutorial, you’ll learn how to use the Excel SUMIFS function to sum cells that match multiple criteria. When aggregating in Excel, you may want to calculate the sum of numerical values that satisfy multiple conditions.The SUMIFS function allows you to find the sum of numbers that … Read more
How to Show Tables in MySQL In this tutorial, you’ll learn how to show a list of tables in MySQL using the SHOW TABLES statement. MySQL SHOW TABLES Syntax The syntax of the SHOW TABLES statement is as follows: SHOW TABLES [{FROM | IN} database_name] [WHERE where_expression | LIKE ‘pattern’] Remarks Database_name: The name of the database … Read more
How to Use the COUNTIFS Function in Excel In this tutorial, you’ll learn how to use the Excel COUNTIFS function. COUNTIFS() is a function to count the number of cells in a range that meet multiple criteria. You can use COUNTIFS() to count cells that contain dates, numbers, or references containing numbers. COUNTIFS() Syntax The syntax of the COUNTIFS() function … Read more