# SQL Data Manipulation Language

> The basic data manipulation SQL statements (SELECT, INSERT, UPDATE, DELETE) are used to query, insert, update and delete data. In addition, eXtremeSQL provides PREPARE and EXECUTE statements as well as BACKUP, RESTORE and VERIFY to manage online incremental backup.

> The eXtremeSQL syntax and detailed information for the SQL DML statements are provided in separate pages. Please use the links below to view the individual statement specs:

> select | Query the database to obtain a result set
> insert | Insert a row or rows into an SQL table
> update | Update one or more rows in an SQL table
> delete | Remove one or more rows from an SQL table
> prepare | Prepare an SQL query statement for later execution
> execute | Execute a prepared query statement
> backup | Perform an incremental backup for an eXtremeDB database
> restore | Restore an eXtremeDB database from an incremental backup
> verify | Test the specified backup for validity