Showing entries 1 to 10 of 67
10 Older Entries »
Displaying posts with tag: How To (reset)
Erstellen von Tabellen mit dem MySQL CREATE TABLE-Befehl in dbForge Studio for MySQL

Es gibt zwei Arten, wie man Tabellen in MySQL-Datenbanken erstellen kann: Ausführen einer Abfrage, die einen CREATE TABLE-Befehl enthält Nutzung der entsprechenden Funktionen von MySQL-bezogenen Tools und IDEs Der erste Ansatz ist hilfreich, wenn Sie Tabellen speziell über ein Skript erstellen müssen. Wenn Sie z.B. eine Tabelle zu einem ganz bestimmten Zeitpunkt erstellen möchten, es […]

The post Erstellen von Tabellen mit dem MySQL CREATE TABLE-Befehl in dbForge Studio for MySQL appeared first on Devart Blog.

How to Create a Table in MySQL

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.

MySQL CONCAT Function: How to Concatenate Strings in MySQL

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.

SSIS Data Types: The No-Sweat Guide with Easy Examples

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.

Configuring an ODBC Driver Manager on Windows, macOS, and Linux

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.

MySQL COUNT() – the Essence, Syntax, and Types

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.

GROUP BY Statement in MySQL With Twelve Examples

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.

MySQL IF – Function and Statement (with Examples)

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.

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

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

Showing entries 1 to 10 of 67
10 Older Entries »