MySQL
How to Migrate From SQL Server to MySQL
One of the standout features of dbForge Studio is its ability to import data from various sources, including ODBC data. This significantly expands your capabilities, both for direct conversion of data stored on different platforms and for the convenient development of database-related objects such as ETL procedures, reports, and more.
How to Connect to a MySQL Database
You can connect to MySQL Server using MySQL Client (the command-line utility) and GUI tools. This article will review each method in detail.
How to Migrate MySQL Database to Amazon RDS or Aurora
In this guide, we are going to walk you through the process of transferring a database from a local machine or a traditional server to AWS with the help of the command line as well as with a convenient GUI - dbForge Studio for MySQL.
How to Check MySQL Version
MySQL is an extremely popular open-source RDMS, and it is widely used by millions of companies and professionals. In this article, you will learn how to check the current MySQL version, and how to update it if necessary.
Awards and Endorsements Recap: Discover the Best dbForge Products of Q2 and Q3 2024
Throughout the second and third quarters of 2024, the Devart team achieved multiple awards for the dbForge product line, winning gold and silver for the DBTA Readers’ Choice Awards 2024 nominations, as well as getting badges from Crozdesk, Sourceforge, G2, and SoftwareSuggest listings. Let's check them out.
How to Restore a MySQL Database with Command Line or Restore Tools
The article gives a deep insight into how to restore MySQL database from a backup file using the mysqldump utility and third-party backup and restore tools, such as dbForge Studio for MySQL, MySQL Workbench, and phpMyAdmin.
How to Enable, Configure, and Use MySQL Query Logging
In this article, we will address questions such as the purpose of query logging in MySQL, why it is important, how to enable and configure it, and more. You’ll find a detailed guide on how to use mysqldumpslow to analyze slow query logs, along with tips on harnessing convenient GUI tools like dbForge Studio for MySQL to your advantage.
Time to Empower Yourself With the Newly Updated dbForge Tools for MySQL 10.1
There's nothing quite like delivering regular feature-packed updates to our dear users—and we've got one for you today. dbForge tools for MySQL have been updated to version 10.1 with extended connectivity and quite a few new tricks to make your work easier and faster. To top it off, you get convenient CLI-powered generation of comparison reports.
Find Invalid Objects in Your Databases
Read on to learn basics about invalid objects and how to identify them in SQL Server, MySQL, and Oracle databases using dbForge Edge or from the command line.
16 Best MySQL GUI Clients for macOS
Take a look at the most convenient and user-friendly MySQL GUI tools (clients) that help you tackle a variety of database development, management, and administration tasks on macOS.
MySQL INT (INTEGER) Data Types With Different Examples
This article explains the SIGNED and UNSIGNED integer data types in MySQL and provides examples to illustrate when and how to use these integer data types effectively.
MySQL INSERT Statement – Inserting Rows Into a Table
The article covers the basic syntax of the MySQL INSERT statement and explains how to work with the INSERT command in the MySQL table using dbForge Studio for MySQL.
MySQL CLI (Command-Line Interface): How to Get Started With MySQL Database Management
The article provides a detailed guide on MySQL Command Line Client and shares useful tips on how to download, install, and get started with it. Read the tutorial to find out the best MySQL client on the market today.
MySQL Performance Monitoring Tools and the Most Important Metrics to Monitor
This article covers some of the most popular MySQL performance monitoring tools alongside the key performance metrics that can help improve and optimize query performance in MySQL databases.
MySQL String Functions in Action
MySQL has a set of built-in functions for data processing, transformation, and analysis. In particular, the following discussion will be about string functions. So, let's find out what they are and when to use them.
MySQL Tutorial
Welcome to our MySQL Tutorial, tailored for both beginners and seasoned professionals! Participate in our MySQL training, led by industry experts, and master the art of database management. This program is your gateway to becoming a proficient and confident MySQL database professional.
Choosing the Best GUI Client for SQL Databases
Most SQL GUI tools share common features that can enhance one’s experience working with a database. We have listed some of the most important ones, as well as made a short comparison table where we analyze the most popular SQL GUI clients and highlight what they have under the hood.
Devart dbForge Product Line and SecureBridge Join the 2024 DBTA Readers’ Choice Awards Contest
The Devart team works non-stop to provide you with the best-in-class products, and we look forward to seeing them win this year. Check the list of our solutions and make sure to support them!
Top 9 Database Documentation Tools of 2024 — Free and Paid Options Unwrapped
Our guide compares dbForge Edge, dbdocs.io, Dataedo, ApexSQL Doc & Redgate SQL Doc to help you choose the right one for your database documentation.
Database Testing – Unveiling the Latest Best Practices and Innovations in 2024
Databases are invaluable for any application that relies on them. Thus, database testing is a critical aspect of ensuring optimal database performance. This article will delve into various types of database testing, methodologies, and practical applications.
How to Add, Show, and Drop MySQL Foreign Keys
A key is typically defined as a column or a group of columns that are used to uniquely locate table records in relational databases (including MySQL, of course). And now that we've covered MySQL primary keys on our blog, it's time to give you a similarly handy guide on foreign keys.
TOP 10 IDEs for SQL Database Management & Administration [2024]
IDEs are comprehensive software products equipped with specialized tools for software development. This article explores the most popular and powerful database-related IDEs, their functionality, advantages, pricing models, and other crucial factors.
How to Connect to a MySQL Database on a DigitalOcean Droplet Using dbForge Studio
Today, accessing and managing databases remotely is a fundamental skill for developers, system administrators, and anyone working with data-driven applications. In this article, we will demonstrate how to establish an SSH connection to a MySQL database on a DigitalOcean Droplet—a virtual private server that can host various applications and databases.
How to Remove Duplicate Rows in MySQL
Duplicates pose an ongoing risk to the data consistency and the overall database efficiency. This article will explore the issue of duplicate records, including their origins, the effects they have on databases, and strategies for swiftly detecting and permanently removing duplicates.
Champs Recap: Devart’s Award-Winning Products in Q1 2024
Last season was quite fruitful in terms of awards scored by our products on independent review platforms. And today, we've got a lot more of those to share. Without further ado, let's get started!
How to Install Windows on a Mac With Parallels and Run dbForge Edge
Though dbForge Edge is Windows-native, you can make it work on macOS. One of the possible ways to do that is to use Parallels Desktop, a macOS-compatible solution that will help you create and manage a Windows environment in order to run dbForge Edge on your Mac.
What’s New in MySQL 8.3: Feature Overview
The latest version of MySQL Server, 8.3, has been available as a General Availability (GA) release for a while. In case you have missed it, here is a brief recap of the newly available features and enhancements.
How to Change a Column Type in MySQL
This article will walk you through the essentials of MySQL, shedding light on the intricacies of column types, and explore scenarios where altering column types becomes a necessity, exemplified through the lens of dbForge Studio for MySQL.
How to Easily Convert Your MS Access Data to MySQL
Microsoft Access is a relational system for managing databases that is used to create small-scale databases for a single user or small teams. MySQL is a robust open-source relational database management system for more extensive data volumes and web applications.
Different Ways to Back Up MySQL Databases and Tables
The article provides an overview of the backup types available in MySQL and describes how-to examples of using the mysqldump command-line utility to take...
The Future of Databases: Exploring Serverless MySQL With PlanetScale
Serverless databases are a modern approach to database technology. Unlike traditional databases, where users have to manage server infrastructure and capacity planning, serverless databases remove those complexities. Users can focus solely on their data and applications, leaving the database infrastructure provisioning, scaling, and maintenance to the service provider.
What Is AWS RDS? Key Features, Advantages, and Connection Guide
This article examines Amazon RDS, exploring its unique features and benefits, and offering a guide to connect to databases in Amazon RDS with dbForge tools.
TOP 10 MySQL GUI Tools for Efficient Database Management on Windows [2024]
Selecting the ideal GUI tool for MySQL and MariaDB databases can be challenging. This article provides a summary of the top functional and user-friendly GUI options for these widely-used database systems. It outlines their advantages and disadvantages and offers extra guidance to assist you in making an informed decision.
MySQL RADIANS() Function
MySQL RADIANS() function takes an input value that signifies an angle measured in degrees, transforms this value into radians, and then outputs the converted result.
MySQL REVERSE() Function
In this article, we will explore the REVERSE function in MySQL, focusing on its syntax, practical examples, and fundamental definitions.
MySQL REPEAT() Function
This article aims to provide a thorough understanding of the REPEAT function in MySQL, covering its basic syntax, practical usage through examples, and essential definitions.
How to Connect to SQL Server in Delphi with Devart SDAC
We will walk you through the process of connecting to SQL Server using Devart SDAC, including installation and examples of how to interact with the components.
New in Delphi DAC: Support for RAD Studio 12, new versions of SQL Server, Oracle, MariaDB, and PostgreSQL
Devart Delphi Data Access Components line of products has received a significant update, making it even more compatible with the new database versions.
MySQL LEAVE Statement
In this comprehensive guide, we delve into the intricacies of the LEAVE statement, a pivotal tool in the realm of MySQL programming.
How to Import/Export MySQL Data to SQL Azure: Using ODBC Driver for Data Migration
In this article, we'll briefly review some advantages of SQL Azure, a Microsoft cloud-based SQL database service, and explore how to export and import data between Azure SQL and MySQL server using a universal ODBC driver for SQL Azure and a powerful MySQL tool - dbForge Studio for MySQL.
Meet the Grand New dbForge Studio MySQL 10.0 With Integrated Source Control!
We don't say that quite often, but here is an update to end all updates, one of the biggest bulks of new features and enhancements that dbForge Studio for MySQL has ever seen.
Make Sure You Don’t Miss the Latest Update of dbForge Tools for MySQL!
Yes, our entire product line for MySQL is getting an update that packs quite a few useful goodies for your daily work with MySQL and MariaDB. Yes, the newly introduced features and enhancements are worth at least a brief look. And yes, if you are an active user of these tools, you can already update them!
How to Connect to Oracle in Delphi with Devart ODAC
This article will explore how to connect to Oracle in Delphi using the Devart ODAC library. We'll cover the installation of Devart ODAC, provide concrete examples of its usage, and even compare it to FireDAC.
How to Connect to MySQL in Delphi with MyDAC: A Comprehensive Guide
We will provide step-by-step instructions on installing MyDAC, demonstrate its usage with practical examples, and compare it with FireDAC to highlight its advantages.
Case Study: How the Engineers of SMD Found a Way to Process Millions of Database Records Faster With dbForge Studio for MySQL
Here comes the success story of Specialized Media Dashboard, a project that comprises an open-source media monitoring system. The specialized media in question encompasses the spheres of journalism, law enforcement, and climate change.
Get the Latest Maintenance Update of dbForge Edge!
Here comes a new maintenance update of dbForge Edge, which delivers support for MySQL 8.1, Oracle Database 23c, and PostgreSQL 16. Make sure you don't miss it!
New in ODBC: Support for Oracle 23c, SQL Server 2022, MariaDB 11, and more
The update features multiple changes and improvements in the Devart ODBC Drivers' quality-of-life.
MySQL ROUND Function Examples
The upcoming tutorial will focus on the ROUND function, which is used to round numeric values for precision and accuracy. Rounding is vital in databases to avoid discrepancies in calculations, particularly with financial and scientific data. The article will provide practical examples and insights into effectively using the ROUND function for reliable results in dbForge Studio for MySQL.
Simplify Your Cross-Database Data Import with dbForge Edge
Microsoft Access is a rather popular relational database system, which nevertheless has a slew of considerable limitations. And if your business requirements grow beyond these limitations, you will need a more advanced solution like Microsoft SQL Server, and your migration from Access to SQL Server will begin with data transfers. This is what we are going to explore in this article.
How to Connect Tableau to MySQL: A Guide for BI Professionals
It is necessary to have a reliable and efficient way to transfer data from databases to the BI tool. MySQL, one of the most popular open-source relational database management systems, comes in here. This article will explore how to connect MySQL to Tableau and share data seamlessly between the two.
