Help Center/ GaussDB/ M-Compatibility Developer Guide(Centralized)/ SQL Reference/ SQL Syntax/ SQL Statements/ DML Syntax Overview
Updated on 2025-10-23 GMT+08:00
View PDF
Share

DML Syntax Overview

Data Manipulation Language (DML) is used to perform operations on data in database tables, such as inserting, updating, querying, or deleting data.

Inserting Data

Inserting data refers to adding one or multiple records to a database table. For details, see INSERT.

Updating Data

Updating data refers to modifying one or multiple records in a database table. For details, see UPDATE.

Querying Data

The database query statement SELECT is used to search required information in a database. For details, see SELECT.

Deleting Data

M compatibility provides statements for deleting data that meets specified conditions from a table. For details, see DELETE.

Copying Data

M compatibility provides a statement for copying data between tables and files. For details, see COPY.

Locking

M compatibility provides multiple lock modes to control concurrent accesses to table data. For details, see LOCK.

Session Management

A session is a connection established between the user and the database. For details about how to modify a session, see ALTER SESSION.

Executing an Anonymous Code Block

M compatibility provides statements for executing an anonymous code block. For details, see DO.

Inserting or Replacing Data

M compatibility provides statements for inserting or replacing data in a table. For details, see REPLACE.

Importing Data from an External File

M compatibility provides a statement for importing data from an external file to a specified table in the database. For details, see LOAD DATA.

Displaying Information

M compatibility provides statements for displaying information. For details, see SHOW.

Parent topic: SQL Statements