All articles: Data Manipulation Language (DML)

Checkout our self-help content, created by our top Experts!
All articles Data Manipulation Language (DML)
Using the SQL_CALC_FOUND_ROWS and MySQL FOUND_ROWS – Querychat
Starting from version 4.0, MySQL has a useful ability to count the number of all suitable records for a query when the number of records is limited by LIMIT, namely, SQL_CALC_FOUND_ROWS comes in handy when we work with databases and tables with a huge amount of records and need to...
How to update the table in PostgreSQL – Querychat
In this article, we will discover how to update the table rows in the PostgreSQL and also how to apply the PostgreSQL update from another table. The UPDATE statement can replace a ton of laborious sampling of the necessary to update lines manually. PostgreSQL UPDATE syntax We use the PostgreSQL...
How to use the SQL Server TRANSLATE function – Querychat
In this article, we will discover what is the TRANSLATE function in SQL Server, why it often compared with the REPLACE function, what syntax it has and how to use it in SQL Server.  What is TRANSLATE function in SQL Server  Let’s look at the syntax of the TRANSLATE function: ...
Converting time in MySQL – Querychat
Sometimes there are situations when we need to compare time, and to do this, we need to convert hours and minutes into seconds or vice versa. Or, for example, we have some output in seconds, but we do not need such units.  In this article, we will learn how to...
Using the SYSNAME special Data type in SQL – Querychat
In this article, we will check what the SYSNAME special Data type is and use it in several examples for better understanding.  SQL SYSNAME Data type is considered part of the variable-length character data types in SQL, which is the nvarchar data type. The difference between these two is that...
Handling Overflow and Out-of-Range errors in MySQL – Querychat
In this article, we will check how to handle Out-of-Range and overflow values, defining them as errors or a valid (with warnings if needed) values by setting the MySQL mode. There are basic errors that are shown by MySQL that can be avoided by defining a non-strict mode, depending on...
SQL Server QUOTENAME Function – Querychat
This article explains the QUOTENAME function in SQL Server. The QUOTENAME is a string manipulation function that adds delimiters to an input string. We can use this function to make sure that a string value becomes a valid delimited identifier. Syntax QUOTENAME ( 'character_string' [ , 'quote_character' ] ) The...
SQL Server Primary Key Constraints and Violations – Querychat
The primary key constraint is one of database constraints that is used to enforce the uniqueness of every row in a table. When we insert a row into a table, we might accidentally insert duplicate values and cause an error. This article demonstrates how to add a primary key constraint...
Error 8152: “String or binary data would be truncated” (T-SQL) – Querychat
This article explains the SQL Server “String or binary data would be truncated” error and how we can identify the column and data that are causing the error. The error happens when we try to insert a string which the size is larger than the column size. The SQL error...
DB2 sql update and select statement – Querychat
The language used by DB2 to access data consists of various SQL statements for manipulating or defining data in the database, including the UPDATE or SELECT statement. The article provides information on how to perform a DB2 SQL UPDATE and SELECT statement with examples. DB2 SQL Examples - Creating the...
1 2 7 8