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. | |