> ## Documentation Index
> Fetch the complete documentation index at: https://docs.cloud.cdata.com/llms.txt
> Use this file to discover all available pages before exploring further.

# SQL Commands

> Connect AI supports several operations on data, including querying, deleting, modifying, and inserting.

## SELECT Statements

See [SELECT Statements](/en/SQL-Reference/SELECT) for a syntax reference and examples.

## INSERT Statements

See [INSERT Statements](/en/SQL-Reference/INSERT) for an example.

## UPDATE Statements

The primary key Id is required to update a record. See [UPDATE Statements](/en/SQL-Reference/UPDATE) for an example.

## UPSERT Statements

An UPSERT statement updates a record if it exists and inserts the record if it does not. See [UPSERT Statements](/en/SQL-Reference/UPSERT) for an example.

## DELETE Statements

The primary key Id is required to delete a record. See [DELETE Statements](/en/SQL-Reference/DELETE) for a syntax reference and example.

## GETDELETED Statements

The GETDELETED query retrieves deleted records. See [GETDELETED Statements](/en/SQL-Reference/GETDELETED) for an example.

## EXECUTE Statements

Use EXECUTE or EXEC statements to execute stored procedures. See [EXECUTE Statements](/en/SQL-Reference/EXECUTE) for a syntax reference and examples.

## INSERT INTO SELECT Statements

An INSERT INTO SELECT statement inserts data from a temporary table. See [INSERT INTO SELECT Statements](/en/SQL-Reference/INSERT-INTO-SELECT) for a syntax reference and examples.

## UPDATE SELECT Statements

UPDATE SELECT statements perform multiple updates in a single request. See [UPDATE SELECT Statements](/en/SQL-Reference/UPDATE-SELECT) for a syntax reference and examples.

## DELETE SELECT Statements

A DELETE SELECT statement performs multiple deletes in a single request. See [DELETE SELECT Statements](/en/SQL-Reference/DELETE-SELECT) for a syntax reference and examples.