Skip to content

CrossDB Shell

CrossDB tool

This tool can

  • Open and operate many local databases.
  • Connect to and operate a remote database server.

Note

xdb-cli creates a default memory database, allowing you to directly create tables for practice.

$ xdb-cli -h
Usage: xdb-cli [OPTIONS] [[path]/db_name]
  -?                        Show this help
  -e <sql>                  Client: Execute command and quit.

Open DB

xdb-cli school

Open DB and Execute Command

xdb-cli -e 'SELECT * FROM student WHERE id=1; SELECT * FROM student WHERE age=10' school

Embedded Shell

Your program can enter the interactive shell using the SHELL statement.

SHELL

xdb_exec (pConn, "SHELL");

Auto Completion

Use TAB to auto-complete SQL statements, keywords, database names, table names, field names, etc.

XDB> <TAB>
CREATE      Create database, table, index, etc
DROP        Drop database, table, index, etc
ALTER       Alter database, table, index, etc
SELECT      Select rows from table
INSERT      Insert rows into table
UPDATE      Update rows in table
DELETE      Delete rows from table
BEGIN       Begin transaction
COMMIT      Commit transaction
ROLLBACK    Rollback transaction
USE         Switch Database
SHOW        Show database, table, index, etc
DESCRIBE    Show Table Schema
EXPLAIN     Show SELECT statement index selection
SET         Config parameters
OPEN        Open database
CLOSE       Close database
DUMP        Dump database
SOURCE      Load SQL file
SHELL       Enter interactive shell
HELP        Help

XDB> S <TAB>
SELECT    Select rows from table
SHOW      Show database, table, index, etc
SET       Config parameters
SOURCE    Load SQL file
SHELL     Enter interactive shell
XDB> SE <TAB>
SELECT    Select rows from table
SET       Config parameters
XDB> SEL <TAB>
XDB> SELECT

XDB> SELECT <TAB>
XDB> SELECT * <TAB>
XDB> SELECT * FROM <TAB>
student    teacher    book
XDB> SELECT * FROM s<TAB>
XDB> SELECT * FROM student

XDB> SELECT * FROM student <TAB>
WHERE       ORDER BY    LIMIT       OFFSET      AND         id          name        age         class       score
info
XDB> SELECT * FROM student WHERE i <TAB>
id      info

XDB> SHOW  <TAB>
DATABASES    TABLES       INDEXES      COLUMNS      CREATE

Comments