Courses
Tutorials
Practice

Similar Topics

Web Technologies37.4K+ articles

Misc8.8K+ articles

DBMS1.6K+ articles

SQL1.5K+ articles

MongoDB736+ articles

DBMS-SQL527+ articles

PostgreSQL394+ articles

mysql330+ articles

SQL-Server319+ articles

MongoDB183+ articles

Databases / MariaDB

MariaDB

83 posts

Showing indexes in MariaDB

Last Updated: 05 March 2024

In the area of database optimization, indexes play an important role in enhancing performance and speeding up query execution. MariaDB which is a powerful open-source rela...read more

article_image

How to Get the Data Type of a Columns in MariaDB

Last Updated: 27 February 2024

When it comes to managing databases, understanding the types of data stored in each column is crucial. In MariaDB, this knowledge not only helps in organizing data efficie...read more

How to Remove All Duplicate Rows Except One in MariaDB?

Last Updated: 27 February 2024

Duplicate rows in database tables can lead to complexity and data integrity issues and affect performance. Removing all duplicate rows while keeping one instance of each u...read more

article_image

How to Rename Column in MariaDB

Last Updated: 27 February 2024

In database management, maintaining an efficient and well-organized schema is important. One common task is to rename columns which can enhance clarity, attach to naming c...read more

article_image

How to Get the First and Last Day of the Month in MariaDB?

Last Updated: 27 February 2024

In MariaDB, working with dates is a common task, and knowing how to manipulate them can be incredibly useful. One common requirement is to find the first and last day of t...read more

article_image

MariaDB Create Triggers

Last Updated: 27 February 2024

Triggers are a very useful and powerful feature of MariaDB. It is a database object associated with a table that activates if an INSERT, UPDATE or DELETE operations are pe...read more

article_image

How to Create User With Grant Privileges in MariaDB

Last Updated: 27 February 2024

In database management, effective user management and privilege assignment are important for secure and efficient operations. MariaDB, a popular open-source relational dat...read more

article_image

Dropping an Index in MariaDB

Last Updated: 20 February 2024

In MariaDB, indexes play a crucial role in enhancing query performance by facilitating fast data access within a table. However, there are scenarios where you might need t...read more

article_image

MariaDB Create View

Last Updated: 20 February 2024

Views in MariaDB are powerful tools that allow us to create virtual tables based on the result set of a SELECT query. They provide a way to simplify complex queries, impro...read more

Union All Operator in MariaDB

Last Updated: 16 February 2024

In MariaDB, the Union All operator is a useful tool for combining results from multiple SELECT queries into a single result set. Unlike the Union operator, Union All retai...read more

article_image

Quote in MariaDB

Last Updated: 16 February 2024

Quotes play a crucial role in MariaDB, the open-source relational database management system known for its speed and reliability. Whether you're a beginner or an experienc...read more

DAYOFWEEK in MariaDB

Last Updated: 13 February 2024

MariaDB is an open-source relational database management system that is a subset of MySQL which is based on SQL(Structured query language). It is an improved version of My...read more

How to Set a Column Value to NULL in MariaDB

Last Updated: 13 February 2024

In MariaDB, the NULL represents an unknown value in a column. Changing a column value to NULL is the most common operation performed in MariaDB that allows us to remove ex...read more

article_image

How to Get Size of MaiaDB Database?

Last Updated: 13 February 2024

MariaDB is an open-source relational database management system that is a subset of MySQL which is based on SQL(Structured query language). It is an improved version of My...read more

article_image

MariaDB GROUP_CONCAT Function to Concatenate Strings

Last Updated: 14 February 2024

In database management, it is necessary to aggregate and concatenate strings from multiple rows into a single, comma-separated string. This is where the GROUP_CONCAT funct...read more

article_image