# eXtremeSQL DML Statements

> DML statements add, modify or remove rows from or perform queries on existing tables. Please use the following links to view the syntax for and examples of the Data Manipulation Language statements:

> insert | Insert a row into an existing table
> update | Modify an existing row in a table
> delete | Remove an existing row from a table
> truncate | Delete all rows from the table
> select | Perform a query on one or more tables
> backup | Perform an incremental backup for an eXtremeDB database
> prepare | Create an SQL statement to be executed later, perhaps multiple times
> execute | Execute an SQL query previously defined and pre-compiled by the `prepare` statement