MySQL SELECT Statement Basics

The article covers the basic syntax of a MySQL SELECT statement and provides examples that show how to use a MySQL SELECT statement to retrieve data from tables.

Read the rest of this entry »

MySQL INSERT Statement – Inserting Row Into a Table

The article covers the basic syntax of the MySQL INSERT statements and explains how to use the INSERT command in the MySQL table using dbForge Studio for MySQL.

Read the rest of this entry »

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 contrast the two systems while maintaining the focus on MariaDB databases. Read on to discover the essential information on MariaDB and learn how to install and connect to your MariaDB database as well as execute simple queries.

Read the rest of this entry »

Continuous Integration with TeamCity and dbForge

Business benefits from faster releases. End-users get updates immediately, their applications and systems work seamlessly, and both the software manufacturers and customers are happy. Thus the idea is to make software development and releases faster and safer. There are lots of tools to automate processes, accelerate performances, and eliminate the risks of errors.

Read the rest of this entry »

How to Create Customizable CRUD Operations with SQL Complete

Working with SQL databases and tables usually implies performing daily data-related tasks using the CRUD operations in order to re-use, manipulate, and access data later. For example, you can create a new table, modify, populate the table with data, retrieve and store data for future use, or delete if needed.

Read the rest of this entry »

New in Delphi DAC: Support for RAD Studio 10.4.2 and Multiple Performance Improvements

Following the release of RAD Studio 10.4.2 Sydney from last week, we are excited to announce support for the new versions of Delphi and C++ Builder IDEs in our data access components. DAC products are now also compatible with macOS Big Sur, iOS 14, and Android 11. Additionally, PostgreSQL 13 was supported in PgDAC.

Read the rest of this entry »

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 why it is crucial to ensure correct data retrieval from databases and appropriate ways of data manipulation. To modify your data properly, you will need to execute SQL queries. The current article will focus on the MySQL UPDATE statement and its use.

Read the rest of this entry »

General Review of Microsoft SQL Server Management Studio (SSMS)

SQL Server Management Studio or SSMS is, perhaps, the most famous product for managing Microsoft SQL Servers and any SQL infrastructure. Many experts consider it the most useful management tool of all. 

Read the rest of this entry »

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.

Read the rest of this entry »

Meet dbForge Fusion for Oracle, v3.10 with Fresh Connectivity Options

We are delighted to share the great news with our Oracle users – a new version of our Visual Studio plugin for Oracle database management, dbForge Fusion for Oracle, v3.10, has been just released!

Read the rest of this entry »