Loading
Learn it from developers who built it.
Tutorials, how-tos and deep dives on AI, .NET, C#, cloud and developer tools, written by the community.
Everything on MySQL, not only its articles: the MySQL page →
In this article you will learn the use case with the select command in MySQL server
In this article we will explain the password encryption function and how to return a password string from a plain text password in a string.
Learn how to use MySQL's SUBSTRING_INDEX function to extract values before or after delimiters and retrieve specific segments from strings.
In this article we will explain how to bind data to a GridView using MySQL Server.
In this article we will see the usage of a stored procedure in MySQL.
In this article we learn the ORDER BY clause in MySQL.In MySQL, the ORDER BY clause is used in conjunction with the SELECT statement to sort the result set based on one or more columns. It allows you to specify the order in which rows should appear in the query result. The ORDER BY clause is a powerful feature that provides control over the presentation of data. Here's a description of how the ORDER BY clause works.
In this article we have to create an ASP.NET website using the DropDownList with the help of the GridView.
In this article we will learn how to handle duplicate records in a MySQL server.Handling duplicate records in MySQL involves identifying and dealing with rows that have identical or very similar data in one or more columns. Duplicate records can occur due to various reasons, such as data entry errors, multiple data imports, or software bugs. Here are some common approaches to handling duplicate records in MySQL.
A simple question that may come to one's mind while working with MySQL is "Whether to assign DATETIME or TIMESTAMP datatype for a column as both seem to store the same data?”. Even though they store the same data, they differ in some ways and let's check those things out with the help of a small example.
In MySQL, the HAVING and AS (Alias) clauses are powerful features used in conjunction with the SELECT statement to filter and rename data retrieved from a table. Let's look at each clause individually.
This article explains how to modify and update a table in MySQL.In MySQL, modifying and updating tables are essential operations that allow you to change the structure and content of your database tables. Here's a brief description of these operations.
In this article we will learn about timestamp formatting in MySQL.
To work with MySQL in Visual Studio 2010, you can use the MySQL Connector/NET, which is a fully-managed ADO.NET data provider for MySQL. This connector enables you to interact with MySQL databases in your Visual Studio projects, allowing you to perform various database operations seamlessly. Here's a step-by-step guide to setting up and working with MySQL in Visual Studio 2010
In this article, we will learn how to connect MySQL with python.
Triggers are powerful features in MySQL that allow you to automate the execution of SQL statements when certain events occur in the database. These all events can include inserting, updating, or deleting data from a table, and triggers can be used to perform complex calculations, enforce business rules, and maintain data integrity. By using triggers. you can save time, and reduce the risk of errors. and ensure that your database operations run smoothly.
the MAX() Aggregate function is used to return the highest value in a set of values in the column. This Aggregate function can be used in various scenarios such as finding the maximum price of a product, the highest score in a test, or the most recent date in a table with the help of the MAX() Aggregate function.
Order by is a useful feature in MySQL that allows you to sort query results based on one or more columns in ascending or descending order. In this article, we will discuss how to use order by in MySQL with step-by-step examples.
The MySQL "BETWEEN" operator is used to filter and retrieve data within a specified range. It compares a value to the lower and upper bounds and includes entries that fall within the range. It can be used with numeric, date, or string values in SQL queries. Examples and syntax are provided in the article.
Group by is a powerful feature in MySQL that allows you to group rows based on a specific column or set of columns. It is commonly used for generating summary reports and performing aggregations on large datasets. In this article, we will discuss how to use group by in MySQL with step-by-step examples.
The LIMIT clause is used to limit the number of rows returned by a SELECT statement in MySQL. It is typically used in combination with the ORDER BY clause to specify the order in which the rows should be returned. The syntax for the LIMIT clause is as follows.
MySQL is a database management system that uses Structured Query Language (SQL) to store, manipulate, and retrieve data. It provides various features such as indexing, data replication, backup, and recovery. MySQL can be used with different programming languages, including Java.
The AVG function in MySQL calculates the average of a selected group of values.
In this article, I am going to explain to you the foreign key constraint.
In this article, you will learn how to use TIME functions in MySQL.
MySQL Stored Procedures are pre-compiled SQL code blocks that are created and stored in the database and may be executed whenever necessary for better performance and security.
In this article, we will read about Introduction to MySQL, its advantages and disadvantages.
Write an article and earn +1,000 SHARP when it is approved.
Write an article
