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