Updated on 2024-01-25 GMT+08:00

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.

Insert Data

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

Updating Data

Modifying 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

For details about how to delete data that meets specified conditions from a table, see DELETE.

Copy Data

GaussDB(DWS) provides a statement for copying data between tables and files. For details, see COPY.

Locking a Table

GaussDB(DWS) provides multiple lock modes to control concurrent accesses to table data. For details, see LOCK.

Run the following statement to invoke the function:

GaussDB(DWS) provides three statements for invoking functions. These statements are the same in the syntax structure. For details, see CALL.