Articles

Showing 1 - 15 of 20 articles with the tag MARIADB

20% OFF for dbForge Studio for MySQL. Limited Time Offer!

If you work with MySQL or MariaDB regularly, you know how important it is to optimize query performance and how easily you can get stuck when you need to export..

Sent 473 days ago

Export MySQL data to CSV: Comprehensive tutorial & best practices

CSV is one of the most versatile data formats that is widely used to exchange structured data between different applications. The convenience of CSV lies in simplicity. CSV files contain..

Sent 463 days ago

MySQL Administration GUI Tool to Make Your Work Efficient

dbForge Studio is a MySQL IDE by Devart that provides a highly versatile feature set to help database administrators and developers manage MySQL and MariaDB databases safely and effortlessly.The Studio..

Sent 456 days ago

How to Copy Table in MySQL: Duplicate Structure, Data, and Indexes Correctly

Copying tables in MySQL is a routine operation performed by DBAs, developers, and analysts dozens of times a day for various reasons and with various purposes. In this tutorial, we..

Sent 449 days ago

Boost Your Database Efficiency: dbForge Studio for MySQL v10.1 and Mini-Tools Deliver New Features

Devart has released an updated product line of dbForge Tools for MySQL v10.1, including dbForge Studio for MySQL – an all-in-one solution for MySQL and MariaDB database development, design, management,..

Sent 434 days ago

Enhance MySQL and MariaDB Workflow With the Latest dbForge Edge

Devart has announced the release of dbForge Edge (v3.1), a comprehensive multidatabase solution that empowers users with a suite of powerful tools designed to streamline database management workflows across MySQL,..

Sent 428 days ago

MySQL INT (INTEGER) Data Types With Different Examples

In MySQL, INTEGER (INT) is a numeric value without a decimal. It defines whole numbers that can be stored in a field or column. In addition, MySQL supports the display_width..

Sent 422 days ago

How to Enable, Configure, and Use MySQL Query Logging

What is the purpose of query logging in MySQL? Why is it important? How do you enable and configure it? This article addresses these questions and more. You will find..

Sent 414 days ago

MySQL INSERT Statement – Inserting Rows Into a Table

The INSERT statement is used to add data to a table. The INSERT INTO command inserts one or multiple rows into a MySQL table. Depending on the number of rows..

Sent 410 days ago

Check History of Executed Queries in MySQL Easily!

The MySQL Query History feature in powerful MySQL IDE - dbForge Studio helps developers and DBAs track past queries, troubleshoot issues, and optimize performance. It provides quick access to query..

Sent 392 days ago

How to Restore a MySQL Database with Command Line or Restore Tools

There may be situations when data gets lost or corrupted, for example, when users accidentally deleted or overwrote data. For these reasons, it is recommended to make a backup on..

Sent 387 days ago

Explore the Power of dbForge Tools for MySQL and MariaDB

If you're working with MySQL or MariaDB, having the right tools for development and administration can make all the difference. Designed for database developers, architects, DBA, analysts, DevOps and other..

Sent 371 days ago

How to Rename a MySQL Database

When working with MySQL databases, you may encounter the need to change a database name. However, MySQL no longer supports a direct renaming option. The RENAME DATABASE command, available in..

Sent 358 days ago

MySQL Subqueries Guide

Subqueries in MySQL are very useful when data manipulation gets complicated. MySQL is among the most powerful and widely used relational databases. Still, retrieving the exact data you need can..

Sent 205 days ago

Aggregate Functions in MySQL: What They Are, Examples, and Best Practices

For developers, analysts, and database professionals working with MySQL, mastering aggregate functions is non-negotiable. A comprehensive guide published by Devart provides a thorough breakdown of how to use COUNT(), SUM(),..

Sent 169 days ago

« Previous
Next »

Showing 1 to 15 of 20 results