All articles: Data Manipulation Language (DML)

Checkout our self-help content, created by our top Experts!
Import Text Files into MySQL – Querychat
MySQL offers us the possibility to import data from external files other than a file with the  ".sql" extension. We can use TXT or CSV files with organized data to populate our tables. To achieve this, we will take a look into the options accepted by the LOAD DATA INFILE...
How to Import XML into SQL Server – Querychat
In this article, we will learn how to import data from XML to SQL Server through a practical example. Import XML to SQL Server To import data from XML to SQL Server, we need two things, the data in XML format and a table in SQL Server where the data...
What is the MS Access Split Function – Querychat
In this article, we will discover what the MS Access Split function is, what the syntax of this function is and also we will look at the detailed examples of its use in VBA code.  The MS Access Split function syntax At times, we need to divide, for example, a...
How To Use The PostgreSQL Max Function – Querychat
Databases have built-in aggregate functions that perform basic as well as advanced aggregation and summary operations, generally on numeric data. PostgreSQL too has several standard aggregate functions like SUM, COUNT, MIN, MAX, and AVG, which are a standard feature of SQL. In this article, we will learn the Postgresql max...
Oracle Error: Inserted value too large for a column – Querychat
This article discusses the ORA 01401 or value too large for a column error in Oracle, which happens because we try to insert a string value that is larger than the column's size. We will also learn the steps to resolve it. In addition, we will take a look at...
The Oracle ORA-00913 and ORA-00947 Errors – Querychat
In this article, we will talk about two common mistakes that can occur during our work in Oracle, namely, when there are not enough values and when there are too many values. Moreover, we will look at ways to solve them. How to solve ORA-00913: too many values For example,...
Oracle ALL and ANY Operators – Querychat
In this article, we will discover the Oracle ANY and ALL SQL logical operators. We use these keywords to compare the value we have with the values that we have in the result of the subquery. We will find out what values we can compare using these operators.  Oracle ALL...
Using the Parse function for SQL Server – Querychat
In this article, we will check how the PARSE function works in SQL Server, including simplified examples for better understanding. The PARSE function allows changing a specific expression to a different data type. The syntax for this function is the following: PARSE ( StringValue AS DataType [ USING Language ]...
What is the correct SQL order of precedence? – Querychat
In this article, we will check what is the precedence in a SQL Query and SQL operator precedence, and how this has an impact on the statement’s execution. Order of Precedence in Select Statements A select statement is based on several conditions that will be executed depending on a specific...
How to debug and fix SQL Server Error 547 – Querychat
This article discusses the causes of SQL Server Error Msg 547, how to debug it, and different ways to resolve it. In an RDBMS, the concept of a primary key and foreign key plays a very important role.  Primary Key: It is a column(or combination of columns) that is used...
1 2 9 10