Skip to content

SQL Statements

Statement Description Note
BEGIN Start a new transaction.
COMMIT Commits the open transaction if exists.
CLOSE DATABASE Close an opened database. Embedded Mode only
CREATE DATABASE Create a database.
CREATE INDEX Create an index on the specified table.
CREATE TABLE Create a new table.
DELETE Delete rows in a table.
DESCRIBE Describe the specified table.
DROP DATABASE Drop a database.
DROP INDEX Drop the specified index on the specified table.
DROP TABLE Drop the specified table.
DUMP DATABASE Dump database into file.
EXPLAIN Returns detailed information on how the query is executed.
HELP SQL statements help.
INSERT Insert data into a table.
OPEN DATABASE Open a database on disk. Embedded Mode only
ROLLBACK Roll back the open transaction if exists.
SELECT Retrieves data from a table.
SET AUTOCOMMIT Set session transaction auto-commit.
SHELL Enter interactive shell.
SHOW COLUMNS Show the list of columns within a given table.
SHOW CREATE TABLE Show the CREATE TABLE statement.
SHOW DATABASE Show the list of databases.
SHOW INDEXES Show the list of indexes associated with a given table.
SHOW TABLES Show the list of tables in database.
SOURCE Load and execute SQL file.
UPDATE Modifies rows in a table.
USE Use the database as the current default database.

Comments