Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
In MySQL, the ENUM data type is used to limit column values to a specified set of options which is useful for categories like colors, status, and gender. Sometimes, it is helpful to display these ENUM values as more descriptive like converting 'P' to "pass" and 'F' to "Fail". The IF() function in MySQL makes this easy by allowing conditional logic within SQL queries. The example below will demonstrate how to use the IF() function to convert ENUM values into user-friendly. Example To understand first let us create a table, DemoTable, which contains an ENUM column UserGender to store ... Read More
In MySQL, triggers allow automatic execution of specified actions in response to INSERT, UPDATE or DELETE events on a table. Often, multiple triggers may be created for the same event and action time (e.g.; multiple BEFORE INSERT triggers on the same table). By default, MySQL invokes these triggers in the order they have created. However, the FOLLOWS and PRECEDES option allows control over the sequence of execution which can be critical in complex data handling. In this article, we will explore how to set the order of multiple triggers for the same event and action ... Read More
In MySQL, the ENUM data type enables you to define a column using only a collection of predetermined values. Each value in the ENUM list is assigned a position number known as an index (which begins with 1). These index numbers represent the positions of the values in the list, not the actual data. For example, if the ENUM list is ('Male', 'Female', 'Other'), Male has an index of 1 while Female has an index of 2 and Other will have an index of 3. This further enables MySQL to store and compare the values more effectively, though actual ... Read More
In this article, we will learn how to find the average of array elements using Python, along with examples to demonstrate the implementation. In this problem, we are given an array of integers, which may contain both positive and negative numbers. Our task is to calculate the average of all elements in the array. Using the Brute Force Approach This is a simple and direct approach. This approach involves manually iterating through each element in the array to calculate the sum. Then, we divide the total sum by the count of elements to get the average. This approach is ... Read More
In this problem, we are given a string, and the task is to toggle the case of each character in the string. This means that all lowercase letters should be converted to uppercase, and all uppercase letters should be converted to lowercase. In this article, we are going to explore different approaches to toggling each character in a string using Python. Let's look at the simple example, where we are going to provide input as "TutorialsPoint". Then output is like "tUTORIALSpOINT" In this case each character is toggled. Such that Uppercase letters become lowercase and lowercase becomes uppercase. Below are ... Read More
Mathematical series is one of the problems that helps us to improve problem-solving and logical thinking skills One of the engaging problems is calculating the sum of the harmonic series. The series 1 + 1/2 + 1/3 + ⋯⋯ + 1/n is known as the harmonic series. In this article, we are going to learn how to find the sum of the series: 1 + 1/2 + 1/3 + ⋯⋯ + 1/n using Python. What is the Harmonic Series? The harmonic series is a mathematical sequence where each term is the reciprocal of a positive integer. It is represented as, ... Read More
Wearable health monitors are used to track our body's activities and functionalities. In this article, I will discuss the 7 best health monitors such as smartwatches and smart rings, their features, and prices. Wearable Health Monitors Wearable Health monitors are smart devices that can track health information such as rate of heartbeat, sleeping patterns, and physical activity. These devices can be worn on your wrist, finger, or any other part of your body. The sensors attached to these devices will collect data from your body and that will be available on your smartphone or computer for tracking and analysis. ... Read More
Searching is one of the most fundamental operations in computer science, and there are multiple algorithms to perform it efficiently. While Binary Search is mainly known to be applied to sorted array searching, Ternary Search is another efficient searching technique that also works on sorted arrays for searching. What is a Ternary Search Ternary Search is a divide-and-conquer algorithm that splits the array into three parts instead of two (as in Binary Search). It repeatedly reduces the search space by two-thirds in each step, making it useful in cases where the dataset is large, and constant-time comparisons are expensive. ... Read More
A cylinder is a three-dimensional geometric shape with two parallel circular bases connected by a curved surface. The volume of a cylinder can be calculated using a mathematical formula that considers its radius and height. Problem Description In this tutorial, we are going to discuss how to find the volume of a given cylinder in Java using different approaches. Formula for Volume of Cylinder The formula for the volume of a cylinder is as follows: Volume of Cylinder = π × r² × h where: r: The radius of the circular base. h: The height of the cylindrical body. ... Read More
What is a Cuboid? A cuboid is a three-dimensional figure with six rectangular faces, where opposite faces are equal in dimensions. We can calculate the volume, perimeter, and surface area of a cuboid using specific formulas based on its length, breadth, and height. Problem Statement Given length, breadth, and height. You need to find its volume, perimeter, and surface area using different approaches in C#. Formulas for Cuboid Calculations The following are the formulas for the volume, perimeter, and surface area of a cuboid: The Volume of a Cuboid: Volume = length × breadth × height The ... Read More