Friday, March 29, 2024

MySQL

Introduction to ADO.NET

ADO.NET is a part of .NET Framework that provides access to different types of data sources. ADO.NET supports relational, XML and application data. ADO.NET...

What is the Difference Between Schema and Database?

Today, we are going to talk about whether schema and database is the same. To be more precise, we will describe the main differences...

WHERE Condition in MySQL with 16 Different Query Examples

In this article, we are going to talk about the WHERE clause and how to use it in MySQL. Besides SELECT, the scope of...

PostgreSQL vs MySQL/MariaDB Comparison: Differences, Performance, and Syntax

When it comes to choosing the database management system (DBMS), questions arise. You need the one that will match your needs and deliver the...

MySQL vs MariaDB: Difference, Performance, and Features (Full Comparison)

There are a lot of relational database management systems on the market today, and choosing the proper one might be quite a challenge. The...

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...

Update Your dbForge Tools to Prevent Diagram Control Errors

If you are using any dbForge tools for SQL Server, MySQL, Oracle, and/or PostgreSQL, please make sure you have read this post. Recently, Microsoft released...

Software Development Life Cycle Tutorial with Examples

SDLC (Software Development Life Cycle) is a series of steps for developing, improving, and sustaining a software system. Learn more about the stages and best practices.  Sometimes we cannot...

Topping the Charts Again: dbForge Studios Awarded G2 High Performer & Leader Fall 2021

More good news coming our way! It is inspiring to see that all the hard work we put into our products pays off as happy...

Data Types in MySQL: Tutorial and Full List with Examples of Data Formats

In the article, we are going to discuss data types including string, numeric, date and time, spatial, and JSON supported by MySQL. Also, we'll...

MySQL INT (INTEGER) Data Types with Different Examples

In the article, you will learn about SIGNED and UNSIGNED integer data types in MySQL. The article provides information about integer types with the...

How to Connect to MySQL Server Databases Remotely

Distributed environment is hardly a new notion in the world of software. For one, you no longer need to host MySQL servers and databases...

What Is InnoDB in MySQL? Tutorial with Examples and Performance Tuning Tips

There is a number of powerful MySQL storage engines at our disposal, and InnoDB is undoubtedly one of the most popular ones. It is...

MySQL for Visual Studio vs dbForge Fusion for MySQL: A Comparison of Plugins

Microsoft Visual Studio plugins continuously compete to empower users with extended capabilities. Free tools have the most obvious advantage — while you don't have...

How to Create a New User Account in MySQL and Grant Permissions on a Database

This article provides a complete overview of how to create a new user account in MySQL and grant different types of privileges on a...

MariaDB Tutorial: An Introductory Guide with Examples

MariaDB is a popular relational database management system (RDBMS) that has a striking resemblance to MySQL. That is why we decided to compare and...

Introduction to MySQL UPDATE Statement

Most modern websites and applications ground on data collection, storage, and analysis. Databases take an active part in building the entire Web environment. That’s...

How to Connect to MySQL Server

In the second article of the series uncovering how to get started with MySQL, we talk about the ways of connecting to MySQL Server. You can connect to...

What is MySQL: The Essence and the Features

Collecting, storing, and processing data are the primary tasks of today. As the data grow, the question of handling them becomes painful. In many...

dbForge Studio for MySQL Gains More User Recognition with 3 Prestigious Awards

dbForge Studio for MySQL is one of the most famous and valuable Devart products - a comprehensive solution with an intuitive interface for MySQL...

dbForge Studio for MySQL vs MySQL Workbench

Every single year new products and new versions of the leading tools enter the market. Their providers compete, offering database specialists more and more...

Devart Joins the Winners’ Circle of 2020 DBTA Readers’ Choice Awards

For the second year in a row, readers of DBTA — a magazine focusing on data, information management, and analytics — choose Devart products...

Top 10 Reasons Why Users Choose dbForge Studio for MySQL

The overwhelming popularity of MySQL means that people need convenient database tools to work with it. Software providers compete to produce the best MySQL...

SSL Connection to MySQL From Delphi with UniDAC and SecureBridge

This article explains how to establish an SSL connection to MySQL from Delphi with UniDAC and SecureBridge. UniDAC has had MySQL SSL (using certificates) connection...

Meet Updated dbForge Tools for MySQL Product Line

We are very glad to tell you about the release of the tools included in dbForge for MySQL product line! The tools comprising the release...

How to kill certain connections to a MySQL database

Maintenance of databases or servers is quite often performed by database administrators at night. But these routines sometimes get blocked by long-running queries...

Entity Framework 6.3 and .NET Core 3 Support

.NET Core 3 .NET Core was presented by Microsoft in 2016, but its 1.x versions had limited set of features comparing to Full .NET Framework....

Apply Integrity Constraint to Your MySQL Database With the Help of dbForge Studio!

Our database tools team is pleased to announce the release of our dbForge MySQL products with a CHECK constraint support. We are looking forward...

MySQL Backup Strategies: How to Backup All and Multiple Databases

This article will outline two approaches to performing regular database backups. The first method involves backing up databases specified in a list, while the second entails bulk backing up of all databases. These procedures can be executed on both Linux and Windows platforms using dbForge Studio for MySQL.

Meet MariaDB 10.4 Support in MySQL Database Tools

We are glad to announce the release of the updated dbForge tools for MySQL. To ensure that the users of our MySQL tools can...

Connectivity to MariaDB Keeps Extending in dbForge Studio for MySQL

We are thrilled to inform our MySQL users that fresh and new dbForge Studio for MySQL, v8.1 has been just rolled out! To ensure that...

Extended Connectivity in dbForge Tools for MySQL

We are excited to inform our users that we have released new versions of dbForge Schema Compare for MySQL, dbForge Data Compare for MySQL,...

Eight Supported by Eighth!

We would like to take this moment to thank the Oracle company for continuous development of the popular MySQL database! As you all might...

MySQL Documenting Has Never Been Easier!

We just love to make our users' life a bit easier. This time, we are excited to treat you with a brand new addition...

Reinvented dbForge Tools for MySQL Have Arrived!

After a grand update of dbForge Studio for MySQL, we haven't forgotten about the rest of the dbForge for MySQL product range. Our developers...

How To Import a .CSV file through the Command Line

In this post, we are going to explore the way of how to import a .csv file through the command line in dbForge Studio...

JSON Support in Entity Framework v4 – v6 in dotConnect for Oracle, MySQL, and PostgreSQL

Recent versions of MySQL and PostgreSQL databases provide JSON functionality support. They introduced special data types, storing JSON data - json data type in...

MySQL Case Sensitive Search in Entity Framework

A high level abstraction provided by Entity Framework sometimes challenges developers in accessing a full set of features available via native SQL of a...

Using HTTP Tunneling

Summary This article elaborates on the HTTP Tunneling connection method and explains how to configure it by means of dbForge Studio for MySQL. Introducing HTTP Tunneling HTTP...

Enhanced Entity Framework Spatials support for Oracle, MySQL and PostgreSQL

Entity Framework v5 and v6 support spatial data types. They are represented as two DbGeometry and DbGeography data types from System.Data.Entity.dll in .NET Framework...

Using MySQL Full-Text Search in Entity Framework

Introduction MySQL database supports an advanced functionality of full-text search (FTS) and full-text indexing described comprehensively in the documentation: Full-Text Search Functions (MySQL 5.5 stable...

Get 20% off on any Devart product (expires January 10th)!

Merry Christmas and Happy New Year! As Christmas holidays are drawing closer, we offer you to get 20% off any product license order. Don’t think twice,...

dbForge Studio for MySQL on Linux Operating Systems

Despite the fact that the dbForge database tools were developed only for Windows platforms, our active users (thanks to Tsvetkov) have found a way...

Comic video about developing dbForge Studio for MySQL

Our company has been working on its own MySQL GUI client development for over 6 years. Many features were implemented in this product in...

Export a MySQL Table to a CSV File Methods Overview

In this article we describe benefits and shortcomings of different ways of exporting data from a MySQL table to the CSV format.

How to Get a List of Permissions of MySQL Users

In this article Devart describes how you can create a list of privileges of MySQL database users with the help of a data reports tool.

Provide your feedback on dbForge Studio for MySQL at UserVoice!

Please take part in voting for the new features for the next version of MySQL GUI Client.

How To: Create a MySQL Database Diagram Using a Sketch Image

With Database Designer database can be created from a sketch without using any external image-viewers. Database Designer tool available in dbForge Studio for MySQL serves for creating database diagrams visually.

dbForge Studio for MySQL has been nominated in Best IDE Product of 2010 DevProConnections Community Choice Awards!

Devart made it to the final of 2010 DevProConnections Community Choice Awards. The awards recognize the best products and services in the industry by...

How To Create SQL Query in One Shot

In this article we describe how to quickly design a MySQL query visually using a special GUI tool - Query Builder.

Social

Products