Creating tables is perhaps the most popular task in database development. In this article, we will review the ways of creating MySQL tables. There are two main ways of creating tables in MySQL databases: Executing a query that includes the CREATE TABLE statement Using the corresponding functionality of MySQL-related tools and IDEs The first approach […]

The post How to Create a Table in MySQL appeared first on Devart Blog.

The MySQL CONCAT function is widely used to concatenate multiple column values into a single column. In this article, we will look into the MySQL CONCAT() syntax, demonstrate to you how to use it, and explore the differences between CONCAT and CONCAT_WS. Contents What is concatenation? MySQL CONCAT() syntax MySQL CONCAT examples Select and concatenate […]

The post MySQL CONCAT Function: How to Concatenate Strings in MySQL appeared first on Devart Blog.

Consider this simple Integration Services package. It’s simple because the task is to upload a CSV file to SQL Server. No transformations. Notice the warning in the OLE DB Destination. It’s a string truncation warning. The source column has 50 characters but the target has only 20. So, what? The package may run without errors. […]

The post SSIS Data Types: The No-Sweat Guide with Easy Examples appeared first on Devart Blog.

This article explains how to install and configure the ODBC Driver Manager on Windows, macOS, and Linux. Also, it shows how to configure the ODBC data source name. Contents What is ODBC Driver Manager? How to Install ODBC Driver Manager Installing and Configuring an ODBC Driver Manager on Windows Installing and Configuring an ODBC Driver […]

The post Configuring an ODBC Driver Manager on Windows, macOS, and Linux appeared first on Devart Blog.

If your occupation has anything to do with databases, you face all kinds of routine tasks on data manipulation every day. Does it mean you have to do them all manually? Of course, not. It would consume all your time and raise plenty of risks. There are many convenient IDEs like dbForge Studio for MySQL […]

The post MySQL COUNT() – the Essence, Syntax, and Types appeared first on Devart Blog.

In this article, we’re going to share the MySQL tutorial how to use the MySQL GROUP BY function as well as this function usage together with and without aggregate functions. Contents What is the meaning of the GROUP BY clause in MySQL? GROUP BY syntax in MySQL Simple GROUP BY example GROUP BY and the […]

The post GROUP BY Statement in MySQL With Twelve Examples appeared first on Devart Blog.

There are two types of IFs in MySQL: the IF statement and the IF function. Both are different from each other.  In this article, we will explain their diversities and show usage examples. Also, we will review other MySQL functions. Contents MySQL IF statements MySQL IF-THEN statement MySQL IF-THEN-ELSE statement MySQL IF-THEN-ELSEIF-ELSE statement Examples of […]

The post MySQL IF – Function and Statement (with Examples) appeared first on Devart Blog.

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 resides in a layer between data sources and client applications and enables customers to retrieve, manipulate and update data through ADO.NET object model. ADO.NET architecture ADO.NET was introduced in the 10th […]

The post Introduction to ADO.NET appeared first on Devart Blog.

In this article, we are going to talk about the WHERE clause and how to use it in MySQL. Besides SELECT, the scope of the WHERE clause includes the UPDATE and DELETE statements. The WHERE clause is indispensable for quality work with MySQL databases. That’s why the current article will deal with this clause and […]

The post WHERE Condition in MySQL with 16 Different Query Examples appeared first on Devart Blog.

If you are looking to improve the performance of MySQL databases in your software, you may need to know all the differences between InnoDB and MyISAM, two well-known types of MySQL storage engines. And if you are about to choose one of them, we believe you would like to find out what each of them […]

The post InnoDB vs MyISAM: A Detailed Comparison of Two MySQL Storage Engines appeared first on Devart Blog.